hi i am new to excel heelllpppp
oops just tried it and it didnt work..... the cell was asking me 4 a name
(=sum(name)..
--
thank u very much
"Gary''s Student" wrote:
Hi Linda:
Let's say wee have numbers in cell Z100 on 7 sheets and want the sum on
sheet eight.
=SUM(Sheet1:Sheet7!Z100)
will do it
--
Gary''s Student - gsnu200730
"lindyphil14" wrote:
i have opened a new work book, within the book there are 7 sheets (mon,
tue,wed etc) on each sheet i have in my first row 12 individual names and my
first column is times (8.00am every fifteen minutes to 10pm) on the bottom
row i have total of hours used in that particular day - eg mon 8.30am -
2.30pm = 6 hours
i would like to open an eighth sheet that would total all hours for the week
for me!! sounds easy doesnt it!! does it? i am lost ..... if anyone could
help that would be great and save me a lot of time away from the calculator
linda
--
thank u very much
|