Sumifs - area

Hi,

In this case, you have to call INDEX & MATCH functions along with SUMIF as follows:

=SUMIF($C$3:$C$14,D18,INDEX($D$3:$G$14,,MATCH(D19,$D$2:$G$2,0)))

This is because you have a grid of sales items, and you have to provide SUMIF with the column you want it to look into.

You can determine that column based on the criteria in cell D19 by using INDEX & MATCH combination.

I hope that helps

Regards