SOLVED

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

New Contributor

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 Replies
best response confirmed by dgiragama (New Contributor)
Solution

@dgiragama Try this:

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

Great, it worked. Thanks a lot.