sumif with multiple conditions

S

Slax

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

Roberto

=SUMPRODUCT(--(A2:A201="Wichita");--(B2:B201="Kansas");--(C2:C201))

Regard
Roberto

"Slax" <[email protected]> ha scritto nel messaggio
: 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??
:
 
B

Bob Phillips

=SUMPRODUCT(--(A1:A100="Wichita"),--(B1:B100="Kansas"),C1:C100)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
A

Ashish Mathur

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"),rangeC))

Regards,

Ashish Mathur
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rows to columns with multiple sets 1
SUMIFS, one criteria range, multiple criteria 2
Help with determining instructor class location. 0
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Why doesn't this work ? 2
Index/Match Functions to Return Concatenated Response 4
WHAT IS THE RIGHT FUNCTION ? 3
Multiple Columns in Sum Range using SUMIFS 1

Top