Countif Function
=COUNTIF(H3:H26,""&B3)-COUNTIF(H3:H26,"="& B4)
Finds all the entries B3 and <B4 by
count the number B3
count the number = B4
Subtract the # =B4 from the # B3
Note: if you wanted the # =B3 and <=B4
=COUNTIF(H3:H26,"="&B3)-COUNTIF(H3:H26,""& B4)
Dan E
"ChrisG" wrote in message
...
I am attempting to use Countif function, e.g.
=COUNTIF(H3:H26,B3)
however I wish to construct a conditional argument
something like this:
=COUNTIF(H3:H26,"B3 AND <B4")
Having terribel time with syntax or just not doable.
Please help.
Thanks Chris
|