Forum Discussion

Rons12763's avatar
Rons12763
Copper Contributor
Sep 19, 2023
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 allo...
Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    Sep 19, 2023

    Hi Rons12763 

     

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

     

    Example:

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

     

Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Sep 19, 2023

Hi Rons12763 

 

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

 

Example:

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

 

Resources