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").

    Many thanks for your help,


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


    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!