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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

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,696
Messages
5,573,684
Members
412,548
Latest member
wallisonlac
Top