solved

Hi all,

I am trying to do a SUMIFS calculation for 5 criterias and having trouble doing so.

helpsumifs.xlsx

I wish to make a table as shown in the excel spreadsheet whereby if I change the values in cell B17:B20, I get the corresponding figure in cells C23:C25.

I am getting #VALUE! each time I try this.

Any help would be appreciated!

Thanks,