View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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??