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

G

Guest

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
 
V

VBA Noob

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 a
answer.

VBA Noo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to copy data from sht 1 to sht 2 according to specific crit 2
How do I sum column C based on a value in Column A? 2
How to return and sum up multiple values 5
Formula to get sum from one 31 sheets to a summary sheet. 7
How do I automatically copy data from one sheet to another? 1
How do I put a formula to sum the same cell across a number of she 2
how do i Save a file with the name i want and with CVS(Command Del 4
HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE? 1

Top