Count Values In One Column Based on Values Of Another Column

Sarah Tanswell

Hi,

I have 2 columns:

1. Client (containing names of my clients)
2. Status (containing the status of the client)

I need a formula that counts the clients in Column 1 that don't have a status of Lost in Column 2.

I have tried with CountIfs and Not(Contains) but with no luck

Thanks!

Paul Newcome

I would suggest...

=COUNTIFS(Client:Client, @cell = "Client A", Status:Status, NOT(CONTAINS("lost", @cell)))

Sarah Tanswell

@Paul Newcome - Thanks - but it didn't work unfortunately. When you say "Client A" do you mean I have to put in a client name? Below is an example of the table. The correct client count would be 5: