Excel 2007 : Summing a column based on multiple criteria in 2 other columns

Hi,

I have searched and can't seem to find a solution that works for me. Basically I have to sum up a column based on criteria in 2 other columns to provide summary information.

For example: Sum Column B where column A = Hardware AND column C = BB

I have attached a workbook with an example. Expected results are on the "summary" sheet.

Thanks in advance for any help. I know this is probably fairly simple but I am drawing a blank for some reason.

Brian

See attached.

In B2:

=SUMIFS(Data!$B$2:$B$19,Data!$A$2:$A$19,A2,Data!$C$2:$C$19,$B$1)

copied down.

you will need to adjust the $B$1 reference in the other subtables.