Hi guys, got stuck with the INDEX/MATCH functions, getting an incorrect result. Need to get a summary by product type by region in the example below (combined number of units of fruit and vegetables for both regions).
When I added =SUMIF($B:$B,"Fruit",((INDEX($C:$H,,MATCH($N2,$C$1:$H$1,0)))))...