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