Sum different cells across multiple sheets

rps199

New Member
Joined
Mar 31, 2015
Messages
10
I’m hoping someone can help. I’ve spent too long trying to crack this!

I have several customer data sheets all have the same format.

Column A has part numbers, top row has weeks. wk1, wk2 etc.
The sheet is used to record sales. I want to sum the total sales by part number across all customers for each week on a master sheet

The problem I have is the part numbers are in different cells in column A and some customers have more part numbers, some less.

So I have managed to do this by using consolidate but I need the data to be dynamic as new customers sheets will be added and sales yet to be recorded.

Is this possible?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

ashakantasharma

Board Regular
Joined
May 28, 2020
Messages
86
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Mobile
  3. Web
You can use the formula =SUMIFS to have the sum based on all the criteria as required. You may also share a sample sheet for us to have practical solution on the same.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,280
Messages
5,571,289
Members
412,376
Latest member
osborne
Top