Formula on worksheet that changes column if copied on new worksheet

Hi all,

I couldn't manage to make it make sense in the title. Let's hope I do here.
So, I am making an excel file that counts stock holding.
On the first worksheet, I have done a sales sheet where I input sales per week for each items throughout the year.
On the next worksheets (12 in total - one per month), I have all my items and their quantity (QTY initial). They also have the quantity used (QTY out) that refers to the first worksheet total sales for all the weeks in a month.
I have done my formulas for January and would like to know if there is a way to copy/paste in the February one so that they count the sales from February.

Why are the Jan formulae so "random" and bear no obvious relationship to the first sheet. Normally we would expect Product list in Month to match the one in first sheet.

If you want to create generic formulare, assign DATES to the WEEK numbers so can check if data is between a start and finish date OR add a test to check if data lies between WK1 and WK4 (say for January)

The likely candidate is SUMIFS to replace the SUM to include a date (month/week) check.

Hi John,
Thank you for your reply and sorry about the delay on mine.
We sell cocktail boxes. Each with different ingredients. That is why they look random to you.
There might have been an easier way to build this worksheet though.

Hi Pete,

Wow! It does work! I did laugh though, but in a good way.
Thank you so much for that!

Pierre.

Hi Bebo,

Thanks for your reply. Here what I am trying to achieve:

I am selling boxes that each contain different ingredients (although some are similar).
I want a worksheet where I can add the sales of each items. And the main issue I'm having is to also make a worksheet that automatically counts (referring to sales) the amount of stock depleted.

Do you believe I should rethink the whole layout?

Let me know.

Thank you.

Thanks Ali,

All done.