Forum Discussion
dgiragama
Mar 28, 2022Copper Contributor
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
dgiragama Try this:
=COUNTIF(E2:EZ2,">"&Summary!B3)
2 Replies
- Riny_van_EekelenPlatinum Contributor
dgiragama Try this:
=COUNTIF(E2:EZ2,">"&Summary!B3)
- dgiragamaCopper ContributorGreat, it worked. Thanks a lot.