Function SUMIF

[Ricky]

Hi guys

It's there any way I can us the function SUMIF with
multiple criteria or conditions on two different columns.
I'll appreciate your help.

 

[Frank Kabel]

Hi
no you can't use SUMIF with more than one criteria. Use SUMPRODUCT
instead
e.g. the following will sum column C based on the criteria in col. A
and col. B
=SUMPRODUCT((A1:A1000=criteria_1)*(B1:B1000=criteria_2),C1:C1000)

 

[JE McGimpsey]

No. Use SUMPRODUCT.


Assume condition 1 in D1, Condition 2 in D2:

=SUMPRODUCT(--(A1:A1000=D1),--(B1:B1000=D2),C1:C1000)


will add all values in C1:C1000 for which the corresponding values in
column A = D1 and in column B = D2.

 

[Guest]

Thanks but It did not work. What I want to do is to add
the numeric values in column I due to the text criteria
on column A and due to the text criteria on column D.
Please help.

 

[Ricky]

I tried bit it did not work. Since my criteria is text
and numeric I'm having an error.

 

[Frank Kabel]

Hi
just adapt the formula like
=SUMPRODUCT((A1:A1000="text1")*(D11000="text2"),I1:I1000)

just replace text1 and text2 with your criteria

 

[Ricky]

It worked, thanks Frank.

-----Original Message-----
Hi
just adapt the formula like
=SUMPRODUCT((A1:A1000="text1")* (D11000="text2"),I1:I1000)

just replace text1 and text2 with your criteria


--
Regards
Frank Kabel
Frankfurt, Germany



.