SOLVED

Countif Ranges

Copper Contributor

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

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @Rons12763 

 

yes, you could do this by using INDIRECT-function:

 

Example:

=COUNTIF(INDIRECT(B1):INDIRECT(B2),B4)

Martin_Weiss_0-1695137087512.png

 

@Martin_Weiss 

 

Thanks!

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @Rons12763 

 

yes, you could do this by using INDIRECT-function:

 

Example:

=COUNTIF(INDIRECT(B1):INDIRECT(B2),B4)

Martin_Weiss_0-1695137087512.png

 

View solution in original post