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