Excelhelppll
New Member
- Joined
- May 21, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi,
I am currently trying to use a countif function to determine the whether certain values meet a certain criteria, in which the criteria is determined by the use of the CELL function --> CELL("contents", G10) as G10 holds a formula.
My formula looks like:
=COUNTIF(A$17:$A$100, "<CELL("contents", G10")
However, it is not going as intended. How can I fix this to make it work?
I am currently trying to use a countif function to determine the whether certain values meet a certain criteria, in which the criteria is determined by the use of the CELL function --> CELL("contents", G10) as G10 holds a formula.
My formula looks like:
=COUNTIF(A$17:$A$100, "<CELL("contents", G10")
However, it is not going as intended. How can I fix this to make it work?