Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|