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