# Formula to incorporate number from Cell

#### howard

##### Well-known Member
I have the following formula below:

Code:
`` =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

Code:
`` =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

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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)

Thanks very much for the help

This does exactly what I am looking for

Replies
5
Views
155
Replies
9
Views
280
Replies
1
Views
393
Replies
1
Views
117
Replies
1
Views
290

1,202,913
Messages
6,052,527
Members
444,588
Latest member
ViJN

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back