Countif does not work


C

c4ec

Hi appreciate help on getting Countif to work on this situation:
=80%
=80%
=100%
<60%

Formula is COUNTIF(A5:A8,G11), where A5:A8 is the table above, and G11
contains >=80%. how do I set a formula to calculate that there are
two counts of ">=80%"? the value returned is zero instead of 2
counts.

I did a =A5=G11, which returned a TRUE.

Regards
 
Ad

Advertisements

G

Guest

Try this:

=COUNTIF(A5:A8,"="&G11)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top