# Excel formula help/question

1. ## 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

2. ## Re: Excel formula help/question

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
news:xNydncp2zvyk3DPfRVn_vg@giganews.com...
>
> 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
>

3. ## Re: Excel formula help/question

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
news:xNydncp2zvyk3DPfRVn_vg@giganews.com...
>
> 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
>

4. ## Re: Excel formula help/question

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" <croberts@tampabay.rr.com> wrote in message
news:%234COGJNcFHA.2936@tk2msftngp13.phx.gbl...
> 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
> news:xNydncp2zvyk3DPfRVn_vg@giganews.com...
>>
>> 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
>>

>
>

5. ## Re: Excel formula help/question

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" <croberts@tampabay.rr.com> wrote in message
> news:%234COGJNcFHA.2936@tk2msftngp13.phx.gbl...
> > 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
> > news:xNydncp2zvyk3DPfRVn_vg@giganews.com...
> >>
> >> 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
> >>

> >
> >

>
>
>

6. ## Re: Excel formula help/question

Biff

"CLR" <CLR@discussions.microsoft.com> wrote in message
news:A55B9396-8825-4FC9-8FB3-3A6EB8BB51B6@microsoft.com...
> 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" <croberts@tampabay.rr.com> wrote in message
>> news:%234COGJNcFHA.2936@tk2msftngp13.phx.gbl...
>> > 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
>> > news:xNydncp2zvyk3DPfRVn_vg@giganews.com...
>> >>
>> >> 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
>> >>
>> >
>> >

>>
>>
>>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1