how do i lookup and sum from serveral wkshts to a recap sht?
 

My spreadsheet has several worksheets plus one of these is a "recap" of all
other sheets. On my recap sheet - I'm trying to find the sum of a specific
name from all the sheets that equal to that specific name. The individual
sheets has the name in one colum with a total in another column.

I have defined a link that contains all spreadsheets with the range where
data exists. I'm having a hard time trying to firgue out how to write the
formula.

Example: Recap Sheet lists several po numbers:
A1 = 101-06
A2 = 102-06

Individual Spreadsheets keeps track of the amount of hours spent on each job
for a certain pay period.
I3 = 101-06 J3= $2000.00
I4 = 103-06 J4 = $1500.00

how do i lookup and sum from serveral wkshts to a recap sht?
 

Yes. It can be done but can you post more info

e.g How many Worksheets

below a example

Assumes A1 = 101-06 on recap sheet and only two sheets

=SUMPRODUCT(--(Sheet2!$I$1:$I$100=A1)*(--(Sheet2!$J$1:$J$100)+(--(Sheet3!$I$1:$I$100=A1)*(--(Sheet3!$J$1:$J$100)))))

If you list sheet names and ranges etc someone will come up with an
answer.

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569092