Forum Discussion
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...
=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.
=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.
- Thank you so much. I could not wrap my thoughts around the proper syntax. This is exactly what I was looking for!
All the best to you.
