Forum Discussion
Solved
Countif Ranges
Is there a way to set the countif ranges by using other cell entries to set the ranges, example: =countif(whatever cell location is in cell B1:whatever cell location is in B2), >1). This would allow you to move the range of the countif by just entering the range in cells B1 and B2.
Ron
Hi Rons12763
yes, you could do this by using INDIRECT-function:
Example:
=COUNTIF(INDIRECT(B1):INDIRECT(B2),B4)
2 Replies
Hi Rons12763
yes, you could do this by using INDIRECT-function:
Example:
=COUNTIF(INDIRECT(B1):INDIRECT(B2),B4)
