Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum between workshhets
Hi all, Feel like a goose used to do this dozens of times but cant get it right ( its been a while ), I need to sum say cell a20 across ( between ) a range of worksheets, I have setup the following A 1 2 3 Z RESULT SHEET On the result sheet I want to sum in cella20 any entries on worksheets 1-3. cheers Pete -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) |
#2
|
|||
|
|||
Hi,
Use =SUM('1:3'!A20) Regards Govind OZDOC1050 wrote: Hi all, Feel like a goose used to do this dozens of times but cant get it right ( its been a while ), I need to sum say cell a20 across ( between ) a range of worksheets, I have setup the following A 1 2 3 Z RESULT SHEET On the result sheet I want to sum in cella20 any entries on worksheets 1-3. cheers Pete |
#3
|
|||
|
|||
thankyou,
appreciated. -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "Govind" wrote in message ... Hi, Use =SUM('1:3'!A20) Regards Govind OZDOC1050 wrote: Hi all, Feel like a goose used to do this dozens of times but cant get it right ( its been a while ), I need to sum say cell a20 across ( between ) a range of worksheets, I have setup the following A 1 2 3 Z RESULT SHEET On the result sheet I want to sum in cella20 any entries on worksheets 1-3. cheers Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge/combine workshhets | Excel Discussion (Misc queries) |