Forum Discussion

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 ...

excel

Formulas and Functions

Riny_van_Eekelen
Mar 28, 2022
dgiragama Try this:
=COUNTIF(E2:EZ2,">"&Summary!B3)

Riny_van_Eekelen

Platinum Contributor

Mar 28, 2022

dgiragama Try this:

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

dgiragama
Copper Contributor
Mar 28, 2022
Great, it worked. Thanks a lot.