SUM cells together based on 2 criteria

[Guest]

Hi,
I need help in figuring this one out. I have 3 columbs, A, B and C. 'A' is
the dollar amount 'B' is the status and 'C' is the department. Now, I want
to have the sum in Cel A50 all dollar amounts that are 'paid' and in '4045'
then in Cel B50 all dollar amounts that are 'paid' and in '4811'.
I tried to use the SUMIF but couldn't figure out how to make it sum the
appropriate cel in columb A based on two criteria?

A..........B...........C
$100...paid......4045
$50.....owing...4045
$40....paid.......4811
$33....over.......4811

Totals Paid

(Cel A50) 4045 ....
(Cel B50) 4811.....

I would appreciate any help.

Thanks
Ivano

 

[Anne Troy]

Try the methods used here, Ivano:
http://www.officearticles.com/excel/sumif_using_multiple_criteria_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[Alan]

=SUMPRODUCT((B1:B100="Paid")*(C1:C10=4045)*(A1:A100))
=SUMPRODUCT((B1:B100="Paid")*(C1:C10=4811)*(A1:A100))
or the modern way,
=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4045),--(A1:A100))
=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4811),--(A1:A100))
Regards,
Alan.

 

[Domenic]

Actually, there's no need to coerce the last argument with a double
negative since Column A already contains numerical values...

=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4811),A1:A100)

Hope this helps!