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