countif

G

Gary

I want to count the number of times information in a row of cells exceeds the
value in one particular cell. This works =COUNTIF(I37:GC37,">=25") when I
specifically want to know how often the value in the row of cells is >=25.
But this does not work when I want to test the value in the row using cell
E37 that varies according to the number I want to test for in the row as
=COUNTIF(I37:GC37,">=E37")
 
B

bpeltzer

Take the cell reference out of the quotes so that it gets evaluated.
=COUNTIF(I37:GC37,">=" & E37)
 
S

ShaneDevenshire

Hi,

Change your formula to

=COUNTIF(I37:GC37,">="&E37)

If this helps, please click the Yes button.
 

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

Excel Use COUNTIF across a range of cells with formulas 0
Countif Conditions - Use of conditions that vary by cell value 1
Formula not working 3
Selecting specific cells in a column using countif 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Using count for an AND statement 1
Conditional function with count 6
How can I 'CountIf' alternate cells? 2

Top