multiple SUMIF criteria

[Markl9869]

Imagine the following columns:
A is the Project#
B is the Cost Type (Exp or Cap)
and C through M (a column for each month of the year) that contains the
invoice amount received.
There are 200 rows of data

I would like to add up all of the Capital invoices for a specific
project...can anyone help?

 

[Pete_UK]

SUMIF is fine if you only have one criterion, but if you have two or
more then you can use SUMPRODUCT. Bob Phillips shows how here:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps.

Pete

 

[Sheeloo]

I hope you are not the one who wants everything in one formula.
Assuming your amounts are in Col C-N (C-M will give you 11 cells only)
enter this in Col O and copy down
=SUM(C1:N1)

Enter this anywhere (other than Cols A, B and O);
=SUMPRODUCT(--(A1:A100="A"),--(B1:B100="Cap"),(O1:O100))

Replace A with your project#.

 

[Markl9869]

This seems to work if I do the function on the same worksheet but I can't
seem to get it to work if i reference the data from another worksheet...

 

[Sheeloo]

Assuming your data is in Sheet2 then replace A1:A100 with Sheet2!A1:A100 and
so on for other columns...

You can also type the formula to =SUMPRODUCT(--( then go to sheet2 and
select the range in Col A then type ="A"),--( and select range in Col B and
so on...