Mar 28 2022 12:32 PM - edited Mar 28 2022 12:33 PM
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
Mar 28 2022 12:53 PM
Mar 28 2022 12:44 PM
Solution