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

## Bookmarks