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

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

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