summing the sheet which are persons names

N

Narnimar

How can I total the perticular cell g3 in summery sheet if sheets which
supposed to be considered are created in the names of persons? My work book
with 20 sheets , g3 cell of summery sheet is for total amount of some 15
sheets g3 out of 20 sheets. (1 sheet kept for summery other 4 are for out of
my scope).Is any possibility?
 
G

Gary Mc

Narnimar,

Enter =sum(FirstSheet:LastSheet!G3) on your summary worksheet and replace
"FirstSheet" with the name of the first worksheet to be included in the total
and "LastSheet" with the name of the last worksheet to be included and then
move the four worksheets to be excluded to the right of the "LastSheet".
 
N

Narnimar

Thanks. you have solved my problem. Now
If I organize this work book for summing a cell value it is tedious to go
through each sheet. Is there any way to lookup and ensure if a cell with
perticular text is in the location or not? Suppose I look for text Total1
value and sum the G3 of every sheet in the G3 of my Summery sheet. What is
the formula to do this?
 
N

Narnimar

In the below explained 20 sheets I work on 15 sheets which are named like
David, Grace, Robert, Peter, Daisy, .....Thorsten. I suppose Every A3 has
text "Total1" and every G3 of the sheets has value. In my summery sheet G3 I
need the total of all these 15 sheets G3. My formula in summery sheet
=SUM(David:Thorsten!G3) will not return correct figure if any of the cell is
dislocated in any one of the sheet. Appriciate if get a suitable lookup
formula.
 
N

Narnimar

In the below explained 20 sheets I work on 15 sheets which are named like
David, Grace, Robert, Peter, Daisy, .....Thorsten. I suppose Every A3 has
text "Total1" and every G3 of the sheets has value. In my summery sheet G3 I
need the total of all these 15 sheets G3. My formula in summery sheet
=SUM(David:Thorsten!G3) will not return correct figure if any of the cell is
dislocated in any one of the sheet. Appriciate if get a suitable lookup
formula.
 
Top