sumif with multiple conditions

[Slax]

Column A is Cities, Column B is States. Column C is Dollars. There
are 200 rows of information. I want to add the values in Column C if
the City is Wichita and the State is Kansas. Can sumif do this??

 

[Roberto]

=SUMPRODUCT(--(A2:A201="Wichita");--(B2:B201="Kansas");--(C2:C201))

Regard
Roberto

"Slax" <[email protected]> ha scritto nel messaggio
: Column A is Cities, Column B is States. Column C is Dollars. There
: are 200 rows of information. I want to add the values in Column C if
: the City is Wichita and the State is Kansas. Can sumif do this??
:

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100="Wichita"),--(B1:B100="Kansas"),C1:C100)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

Hi,

While sumproduct is the most effective way of solving this problem, another
way of achieving the same result is by using an array formula (Ctrl+Shift+Del)

=sum(if((rangeA="Wichita")*(rangeB="Kansas"),rangeC))

Regards,

Ashish Mathur

 

[Dave Peterson]

I bet you meant ctrl-shift-enter (not Ctrl+Shift+Del).

 

[Slax]

Thanks to all of you. Works like a Champ!!!