Sum Formula

M

mjh

I have a workbook with sheets for every day of the month - from 1st 30 31st.
I want to sum cells from all sheets and I'm using the following:

=sum('1st':'31st'C12)

but it won't work. I know it's probably something to do with the fact that
there are numbers rather than text but I can't work it out. Can someone
please help?

TIA and very grateful if someone can.

Michele
 
T

Thomas A. Rowe

First you will need to post this the Excel newsgroup. This is the FrontPage newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
S

Stefan B Rusynko

This is a FrontPage Newsgroup, not an Excel Newsgroup

PS
Click the cell where you want to enter the function.
Type =SUM(
Click the tab for the first worksheet to be referenced.
Hold down SHIFT and click the tab for the last worksheet to be referenced.
Select the cell or range of cells to be referenced in the last sheet.
Complete the formula by typing a )
and press ENTER.



|I have a workbook with sheets for every day of the month - from 1st 30 31st.
| I want to sum cells from all sheets and I'm using the following:
|
| =sum('1st':'31st'C12)
|
| but it won't work. I know it's probably something to do with the fact that
| there are numbers rather than text but I can't work it out. Can someone
| please help?
|
| TIA and very grateful if someone can.
|
| Michele
 
Top