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