sumif with multiple conditions
 

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??

sumif with multiple conditions
 

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

Regard
Roberto

"Slax" ha scritto nel messaggio
ups.com...
: 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??
:

sumif with multiple conditions
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Slax" wrote in message
ups.com...
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??

sumif with multiple conditions
 

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"),range C))

Regards,

Ashish Mathur

"Slax" wrote:

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??

sumif with multiple conditions
 

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



Ashish Mathur wrote:

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"),range C))

Regards,

Ashish Mathur

"Slax" wrote:

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??



--

Dave Peterson

sumif with multiple conditions
 

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