Countif Function Help

[fareedexcel]

Hi Users,

I tried using the countif forumla, to count a specific type of value. But it's not counting. Please help

Sample file attached for your reference.

 

[deciog]

Try this way

Decio

 

[Peter Bartholomew]

The problem is that ">=" has special significance at the start of a criterion in COUNTIFS. If you replaced the initial ">" by a wildcard character "?", the formula should work (though it would also match "<=".

 

[fareedexcel]

Thanks for your help much appreciated.