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

Need Help with a VBA subroutine 0
Sorting Multiple Tables 1
Transfer data between two tables 3
Indenting every other paragraph in Word at the same time? 0
Macro to select and delete levels of a document 2
Using <= in countifs statement 1
Multiple Nested If Function 6
Copy addition formula of non-consecutive horizontal cells 2

Top