CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE

S

strinnes

Hi! I want to sum column B (Count) if column A (State) equals "NY" and "VA" to give a sum of 12.

Thanks in advance to all responses! :eek:)

STATE COUNT
NY 5
TX 10
VA 7
 
I

isabelle

hi,

=SUMPRODUCT(($A$2:$A$4="NY")+($A$2:$A$4="VA"),($B$2:$B$4))

isabelle

Le 2013-09-16 19:45, (e-mail address removed) a écrit :
 

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

Find Oldest date based on two criteria. 1
Looking formula that SUM values with specific value in neighboring colum 2
How to count the number of times a number is repeated in a column 2
SUMIF with alphanumeric criteria range question 3
Excel 2013: AutoFilter and SUM() 1
Countif with multiple text values in cell 3
COUNTIFS with No Criteria 1
Help with Conditional SUMIF Formula 4

Top