Sumif Index match with multiple column headings same criteria

[derekjames]

Hello. I'm trying to write a formula that sums the values in column C and E (both headers are the same criteria) IF it matches a value in column B. I can write a sumif( Index( Match formula but it only sums column C as it's the first column with the required criteria and ignores column E.

Please see attached workbook. Where i have results you can see the formula i currently have below. Thanks!

=SUMIF($B$3:$B$15,C33,INDEX($C$3:$G$15,0,MATCH(C$25&D$25,$C$1:$G$1,0)))

Another way to say it is I want the sum of all Apple Sales units in the NE, NW, SE seperatly. However, Apple sales units are in column C and in column E and I need to count Apple sales units from both. Same would go for Orange sales units

[NBVC]

tRY:

=SUMPRODUCT(($B$3:$B$15=C26)*($C$1:$G$1=C$25&D$25),$C$3:$G$15)

[derekjames]

Awesome! thanks so much.