Forum Discussion

dgiragama's avatar
dgiragama
Copper Contributor
Mar 28, 2022
Solved

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

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

 

Resources