COUNTIF fuction does not count when criteria points to a differnt cell

[dgiragama]

Hi All,

I am trying use the "countif" function and point to a different cell for the criteria. 

Here is my formula. =COUNTIF(E2:EZ2,">Summary!B3")

Even if I point to differnt cell in the same tab this does not calculate. Just shows zero. If I use a number directly as the criteria the formula calcuates accurately. =COUNTIF(E2:EZ2,">35").

Can anyone assist with this? 

thanks

[#2 · Accepted solution]

@dgiragama Try this:

=COUNTIF(E2:EZ2,">"&Summary!B3)

[#3]

Great, it worked. Thanks a lot.