Thread: countif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default countif

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

"Gary" wrote:

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")