Jodi,

It's a formula with cell references to other sheets in the workbook. I
trust those asterisks aren't in the formula. taking it piece by piece:

='1'!A1 This refers to A1 on sheet named 1.
+'2'!A2 plus cell A2 on the sheet named 2, etc

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jodi" <Jodi.1qlhby@ wrote in message
...

Hi all,

I am trying to copy a spreadsheet created by a Excel genius who is no
longer around to help me.
Basically it is a utilization spreadsheet that tracks services for a
massage operation. In the Grand Total area he set up a *"service"
*column, *"rooms/day"* column and a *"staff"* column.
I was able to figure out how we got rooms/day (for example =A$1*$A$1
where A$1 is the number of rooms available and $A$1 is the number of
days in a given month) but the formula for the staff column is giving
me a headache. Its format is *='1'!A1+'2'!A2+*and so on until *'31'!A1*
for 31 days in the month. Is this a statistical function because clearly
one does not enter in this formula. Thank you to anyone who can help or
point me in the right direction!


--
JodiPosted from http://www.pcreview.co.uk/ newsgroup access