Countifs Excluding Certain Items

[Howardc1001]

I have values in A4:A23 and Text in A4:A23


I tried to set to a formula below to exclude ceratain branches where values are < 0. I should get 12 , but get 14

Please Login or Register  to view this content.

It would be appreciated if someone could kindly check my data and amend my formula

[HansDouwe]

Why do you expect 12? I count 14 that meets the specified criteria.

[Howardc1001]

Thanks Hans-You are 100% Correct. My Apologies

[HansDouwe]

You are Welcome!