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