countif

D

david

I want to count the # of cells greater than a calculated
value (reference cell). I get a 0 returned.

Example: =countif(A3:A5,">C5") returns 0.
 
V

Vasant Nanavati

Try:

=COUNTIF(A3:A5,">"&C5)

Concatenating the ">" operator with the cell reference yields the criterion
string.
 

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

Newbie Help - IF Yes No Function 0
Multiple arguments 3
Using <= in countifs statement 1
Excel Countif Function - Calculating Between Two Sets of Values 3
countifs Function not giving desired result with date criteria 2
Sumproduct not working 5
Countif(and 2
Excel 2010 countifs for date range 3

Top