Excel formula help/question
 

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

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

Like Earl says, the '1', '2'......'31' refers to Sheet Names........and your
sample formula that uses them is just adding cell A1 of all 31 sheets
together. If you don't see those sheets on the tabs below, they may be
hidden. If so, try Format Unhide........

As for the formula =A$1*$A$1..........that don't make a whole lot of sense
to me......it's just multiplying a cell times itself........perhaps it's a
type-O? A$1, $A$1, $A1, A1 are all the same cell.

hth
Vaya con Dios,
Chuck, CABGx3


"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

Hi Chuck!

As for the formula =A$1*$A$1..........that don't make a whole lot of sense
to me......

I'll bet that formula is intended to be copied across so that you get:

B$1*$A$1
C$1*$A$1
D$1*$A$1
etc

Biff

"CLR" wrote in message
...
Like Earl says, the '1', '2'......'31' refers to Sheet Names........and
your
sample formula that uses them is just adding cell A1 of all 31 sheets
together. If you don't see those sheets on the tabs below, they may be
hidden. If so, try Format Unhide........

As for the formula =A$1*$A$1..........that don't make a whole lot of sense
to me......it's just multiplying a cell times itself........perhaps it's a
type-O? A$1, $A$1, $A1, A1 are all the same cell.

hth
Vaya con Dios,
Chuck, CABGx3


"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

Hi Biff......

Uh-huh, good point, that never occured to me......but how about

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)

Vaya con Dios,
Chuck, CABGx3


"Biff" wrote:

Hi Chuck!

As for the formula =A$1*$A$1..........that don't make a whole lot of sense
to me......

I'll bet that formula is intended to be copied across so that you get:

B$1*$A$1
C$1*$A$1
D$1*$A$1
etc

Biff

"CLR" wrote in message
...
Like Earl says, the '1', '2'......'31' refers to Sheet Names........and
your
sample formula that uses them is just adding cell A1 of all 31 sheets
together. If you don't see those sheets on the tabs below, they may be
hidden. If so, try Format Unhide........

As for the formula =A$1*$A$1..........that don't make a whole lot of sense
to me......it's just multiplying a cell times itself........perhaps it's a
type-O? A$1, $A$1, $A1, A1 are all the same cell.

hth
Vaya con Dios,
Chuck, CABGx3


"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

Yeah, that made me scratch my head when I read it!

Biff

"CLR" wrote in message
...
Hi Biff......

Uh-huh, good point, that never occured to me......but how about

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)

Vaya con Dios,
Chuck, CABGx3


"Biff" wrote:

Hi Chuck!

As for the formula =A$1*$A$1..........that don't make a whole lot of
sense
to me......

I'll bet that formula is intended to be copied across so that you get:

B$1*$A$1
C$1*$A$1
D$1*$A$1
etc

Biff

"CLR" wrote in message
...
Like Earl says, the '1', '2'......'31' refers to Sheet Names........and
your
sample formula that uses them is just adding cell A1 of all 31 sheets
together. If you don't see those sheets on the tabs below, they may be
hidden. If so, try Format Unhide........

As for the formula =A$1*$A$1..........that don't make a whole lot of
sense
to me......it's just multiplying a cell times itself........perhaps
it's a
type-O? A$1, $A$1, $A1, A1 are all the same cell.

hth
Vaya con Dios,
Chuck, CABGx3


"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