Summing a grid using Criteria

[jblack]

Hi Forum,

I have a grid of Monday thru Friday for the columns and a criteria column for Cost Type and then there are several rows of cost by cost type (see uploaded example file).

I need to know the total sum in the entire grid for each Cost Type. So far, the best way to accomplish this I come up with is to do a SUMIF by Cost Type on each of the Day of the Week columns and then do a sum of all five days for each Cost Type.

Is there a single formula approach that will treat the entire grid as a range and sum based on a single criteria?

Thanks for your help.

 

[NARAYANK991]

Hi ,

You can use the SUMPRODUCT function , as in :

=SUMPRODUCT(($A$2:$A$5="L")*(B$2:F$5))

Narayan

 

[jblack]

Hi ,

You can use the SUMPRODUCT function , as in :

=SUMPRODUCT(($A$2:$A$5="L")*(B$2:F$5))

Narayan

Thanks Narayan. This is exactly what I was looking for, but was unfamiliar with what SUMPRODUCT was for.