Add Up Various Colums From Various Sheets (Sumproduct)?

[Tony Di Stasi]

Need to pull in data from various sheets according to
particular criteria.

WorksheetName BookName Total
020104 GF15 500
020204 GF15 1000

I therefore need some sort of sum formula that looks up at
every sheet and finds the sum next to the GF15 identifier
on every different sheet--- the GF15 will not necessarily
be in the same place. I don't want to use consolidate
function if possible. Thank!! The result should look like:

BookName Total
GF15 1500

 

[Frank Kabel]

Hi
try
=SUMIF(INDIRECT("'" & A2 & "'!A:A),B2,INDIRECT("'" & A2 & "'!B:B))

 

[Tony Di Stasi]

Hi,

sorry no luck. Getting error message

-----Original Message-----
Hi
try
=SUMIF(INDIRECT("'" & A2 & "'!A:A),B2,INDIRECT("'" & A2 & "'!B:B))

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[Frank Kabel]

Hi
I assume a #REF error?. So paste teh exact formula you have used, the
exact content which is in the referenced cells and the exact sheet name

 

[Tony Di Stasi]

Hi,

Sent you the actual spreadsheet with samples. Thanks
again.