Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula do I use
I have a summary sheet and 11 worksheets. each worksheet has a team members
name on it . I have on the summary sheet two coulmns column a and b Column A Column B Date Overs Bowled 3/01/09 10/01/09 17/01/09 etc In Column B I want to enter a formula so that the date from column A will be added up in all the 11 worksheets. I have tried VLOOKUP but it will not work for all 11 worksheets . Is there a formula that I could use in colmun B to sum all 11 worksheets. On each Team Members worksheet I have Column A Column B Column C Column D Date Overs Bowled Runs Scored Balls Faced Thank you. -- barry |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula do I use
Well, if the dates are on the same row then you can write a formula like
=SUM(Sheet2:Sheet12!B2) This will sum the content of B2 on all the sheets. If this isn't the case, that the values are not on the same row then you will need to do =VLOOKUP(A2,Sheet2!A1:D10,2,FALSE)+VLOOKUP(A2,Shee t3!A1:D10,2,FALSE)+... -- If this helps, please click the Yes button Cheers, Shane Devenshire "barry" wrote: I have a summary sheet and 11 worksheets. each worksheet has a team members name on it . I have on the summary sheet two coulmns column a and b Column A Column B Date Overs Bowled 3/01/09 10/01/09 17/01/09 etc In Column B I want to enter a formula so that the date from column A will be added up in all the 11 worksheets. I have tried VLOOKUP but it will not work for all 11 worksheets . Is there a formula that I could use in colmun B to sum all 11 worksheets. On each Team Members worksheet I have Column A Column B Column C Column D Date Overs Bowled Runs Scored Balls Faced Thank you. -- barry |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula do I use
Hi
If your dates on the Summary Sheet are in the same rows on your 11 source sheets, simply use =SUM(Sheet1:Sheet11!B2) If not, try this multiples VLOOKUP formula This assume that all the dates appear in your source sheets and summary sheet =VLOOKUP(A2,Sheet1$A$2:$D$4,2,0)+VLOOKUP(A2,Sheet2 !$A$2:$D$4,2,0)+ VLOOKUP(A2,Sheet3!.....) until all 11 source sheets. I am still working out a solution if you have missing dates in your source sheets I do not have access to Excel as I am traveling HTH -- Your feedback is very much appreciate, pls click on the Yes button below if this posting is helpful. Thank You cheers, francis "barry" wrote: I have a summary sheet and 11 worksheets. each worksheet has a team members name on it . I have on the summary sheet two coulmns column a and b Column A Column B Date Overs Bowled 3/01/09 10/01/09 17/01/09 etc In Column B I want to enter a formula so that the date from column A will be added up in all the 11 worksheets. I have tried VLOOKUP but it will not work for all 11 worksheets . Is there a formula that I could use in colmun B to sum all 11 worksheets. On each Team Members worksheet I have Column A Column B Column C Column D Date Overs Bowled Runs Scored Balls Faced Thank you. -- barry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|