Sum data from many sheet on the base of a Criteria(Help)

[vidplaylist]

I am struggling how to sum data from many sheet on the basis of a criteria. In my case its "part number" for which i want to sum the quantity from different location sheets.

Thanks,

 

[jeffreybrown]

The most direct method would be to use a Sumif on each individual sheet and then invoke a Sum across sheets.

=SUM(Sheet1:Sheet3!A1)

A1 on each sheet would contain the Sumif value

 

[Trevor G]

Take a look at using SUMIF on eahc sheet then sum the sheets

Samples below:

Excel Workbook
	A	B	C	D
1			Part Number	totals
2			AS2	23
3			AS5	12
4
5
6
7
8
9
10
11
12	Parts	Totals
13	AS2	23
14	AS5	12
Sheet6

Excel Workbook
	A	B	C	D
1			Part Number	Value
2			AS2	34
3			AS5	12
4			AS2	23
5			AS5	34
6			AS2	4
7			AS5	56
8			AS2	554
9			AS5	1
10
11
12	Parts	Totals
13	AS2	615
14	AS5	103
Sheet7

Summary

Excel Workbook
	C	D
1	Part Number	totals
2	AS2	638
3	AS5	115
Summary