Hello,

I am a beginner to excel who is learning everything from bottom up for a project!

I need help building a formula that will sum a specific cell in a named range across several sheets. This cell will be in a constant column, but will be changing row locations depending on where it is pasted.

To be specific:

I am keeping an inventory of items in a stock room. I've named the range based on the name of the product. Eg, "AppleJuice" The named range contains several columns of information about this product, but the one I'm concerned with is in Column J (Total Bottles Used).

I will be updating the inventory through daily sheets and need to sum up how many bottles are being used over the course of several sheets. That sum is then being subtracted from the Total Inventory of Bottles.

The current formula I have is =SUM(First:Last!J4)

This is working for now because it sums up all of this cells information from the first to the last sheet I am using. The problem is, is it means I HAVE to paste the named range in the 4th row.

Is there anyway to sum this up, perhaps using an INDEX formula so that when the row changes, I can still sum up a specific column of in a Named Range?

Thanks,
Mac