Match & sum

[sur]

Hello All,

I have a requirement, where in i have a master sheet, with Sheet Name reference, column Name,

what i have to do is

=Sum(sheetname reference with indirect formula),column Name reference in master sheet, where the columns in data sheet is in A5:D5).

 

[James006]

Hello,

With the Sheet Name in cell A1...

You can test following :

=SUM(INDIRECT(A1&"!A5:D5"))

Hope this will help

 

[sur]

this is fine, but i need to match the cell value to the column & then sum the matched column.

 

[Eric W]

Possibly:

Book1
	A
1	Sheet10
2	Sales
3
4	66.5
Sheet6

Cell Formulas
Range	Formula
A4	=SUMPRODUCT(INDIRECT("'"&A1&"'!A2:E100")*(INDIRECT("'"&A1&"'!A1:E1")=A2))