Formula to incorporate number from Cell

[howard]

I have the following formula below:

 =COUNTIFS('New Inventory'!$AI:$AI,Overaged!C$3,'New Inventory'!$AK:$AK,Overaged!$AI4)

I would like to set up a list of numbers in my workbook F1 to F10 for eg
1
2
3
4
5
6
7
8
9
10


I would like to incorporate the numbers into the last part of the formula so that if I copy the formula so from B4 to B6, I want the last item in the
formula to link to a number so that Overaged!$AI4 changes to Overaged!$AI5 and not Overaged!$AI6

Formula should look like this but not sure how to do this

 =COUNTIFS('New Inventory'!$AI:$AI,Overaged!C$3,'New Inventory'!$AK:$AK,Overaged!$AI&F5)

It would be appreciated if someone could kindly assist me in resolving this

 

[konew1]

Your question doesn't make it clear what determines the number of rows to increment by. Whatever, you need use =INDIRECT function.

Maybe
=COUNTIFS('New Inventory'!$AI:$AI,Overaged!C$3,'New Inventory'!$AK:$AK,INDIRECT("Overaged!$AI"&F5)

 

[howard]

Thanks very much for the help

This does exactly what I am looking for