SUM cells together based on 2 criteria
 

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

Try the methods used here, Ivano:
http://www.officearticles.com/excel/...ft_excel.h tm
************
Anne Troy
www.OfficeArticles.com

"Ivano" wrote in message
...
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

=SUMPRODUCT((B1:B100="Paid")*(C1:C10=4045)*(A1:A10 0))
=SUMPRODUCT((B1:B100="Paid")*(C1:C10=4811)*(A1:A10 0))
or the modern way,
=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4045),--(A1:A100))
=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4811),--(A1:A100))
Regards,
Alan.
"Ivano" wrote in message
...
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

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!

In article ,
"Alan" wrote:

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