Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting text criteria
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. |
#2
|
|||
|
|||
Counting text criteria
=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 -- Regards, Peo Sjoblom "Belinda" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Counting text only | Excel Worksheet Functions | |||
Counting multiple cells using a criteria | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |