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

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

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

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

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

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