Forum Discussion

wowakan's avatar
wowakan
Copper Contributor
Jan 06, 2022
Solved

Auto updating ranges based on different cell values

Dear Help Board,   I have tried unsuccessfully to figure this out and am wondering if it can only be done with VBA or a macro?   I have the following formula and want to dynamically update the va...
excel
Formulas and Functions
Macros and VBA
  • OliverScheurich's avatar
    OliverScheurich
    Jan 07, 2022

    wowakan 

    =COUNTIFS(INDIRECT(T23&":"&T24),">0",INDIRECT(T23&":"&T24),"<1")

     

    Is this what you want to do? You can manually change the range by entering e.g. AA14 and AA29 in cells T23 and T24 as shown in the attached file.

Doug_Robbins_Word_MVP's avatar
Doug_Robbins_Word_MVP
MVP
Jan 07, 2022
Where are the "cell values" based on which the range AA9:AA29 should be modified?
wowakan's avatar
wowakan
Copper Contributor
Jan 07, 2022

Doug_Robbins_Word_MVP 

 

Thanks for the reply.  The cell values are currency values.   I simply want to make a formula where I can adjust the range from ex.  1 to 10 from another cell that contains the values 1 and 10.  Is this possible?

 

Then by altering the cell values let's say from 1 to 10 I can adjust the range for example to 4 to 6 in the same row.

 

Thanks for any help you can offer as this has me stumped.

Resources