Counting text criteria

G

Guest

I have two columns Column A contains contract numbers, i.e. s4802,
s5601--column b contains status words i.e. pending, approved, withdrawn. I
need a formula that will provide a count of each status by contact.
 
P

Peo Sjoblom

=SUMPRODUCT(--(A2:A100="s4802"),--(B2:B100="pending"))

or better

=SUMPRODUCT(--(A2:A100=C2),--(B2:B100=D2))

where C2 holds the contract you want to check and D2 the status, that way
you won't have to edit the formula when you change the criteria
 

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

need help on count entires with conditions 8
Count with 1 variable & 1 constant criteria formula 3
Counting Multiple Records by specific criteria 5
countif programming function 4
countifs Function not giving desired result with date criteria 2
Sumproduct help again 6
Access Dcount (multiple criteria) 3
Split column contents (de-concantenate) 7

Top