# is it possible to use an inputted cell value as the number of the starting row in a range?

• Hi,

I hope you are all well. I have a number of Countifs in a spreadsheet to count how many people on a waiting list will have been waiting over 12 weeks each month over many months, with each column being a month, and each row the number of weeks a person has been waiting, in descending order e.g. Countif(A2:A5000,">12"). I need to look at the impact of increasing activity. So for example if we saw an extra 50 people the Countif would start at row 52 the following month/column instead of row 2. I need to look at various scenarios which would be a huge manual task to keep amending all the Countifs. I wondered of it is it possible to vary the "2" in A2 using a value inputted into a cell, rather than changing it manually in each Countif? e.g. Countif(A plus 'value in cell A1':A5000,">12").

Pete

• Assuming you enter that value in B1, then try:

=COUNTIF(INDEX(A2:A5000,B1-1):A5000,">12")

Where there is a will there are many ways. Finding one that works for you is the challenge!

Edited once, last by NBVC ().

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!