Help with creating a formula

Here is what I'm trying to do. I have a woorkbook with 32 sheets in it 31 of
them are the same and will be as days of the month, the last sheet is used to
track commisions. I would like to be able to automate the process to move
the sold information from 5 different cells, meaning if there is anything in
those cells move the name information to the commision page. Please help!

Summarised?

=SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:31"))&"!A1")))

or just referenced

=INDIRECT(COLUMN()&"!A1")

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jaysphotos" <jaysphotos@discussions.microsoft.com> wrote in message
news:1F55B470-99DF-42DD-BB17-F0ED77269F55@microsoft.com...
> Here is what I'm trying to do. I have a woorkbook with 32 sheets in it 31
of
> them are the same and will be as days of the month, the last sheet is used
to
> track commisions. I would like to be able to automate the process to move
> the sold information from 5 different cells, meaning if there is anything
in
> those cells move the name information to the commision page. Please help!

Bob,

Thanks for the help. Maybe I don't understand should I type just as you
have or do I make changes. It might be easier if I was able to get you a
screen shot contact jaysphotos@same .com

"Bob Phillips" wrote:

> Summarised?
>
> =SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:31"))&"!A1")))
>
> or just referenced
>
> =INDIRECT(COLUMN()&"!A1")
>
> etc.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "jaysphotos" <jaysphotos@discussions.microsoft.com> wrote in message
> news:1F55B470-99DF-42DD-BB17-F0ED77269F55@microsoft.com...
> > Here is what I'm trying to do. I have a woorkbook with 32 sheets in it 31
> of
> > them are the same and will be as days of the month, the last sheet is used
> to
> > track commisions. I would like to be able to automate the process to move
> > the sold information from 5 different cells, meaning if there is anything
> in
> > those cells move the name information to the commision page. Please help!
>
>
>

I think you should try giving more detail. I offered a couple of options as
it was not clear exactly what you were trying to do.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jaysphotos" <jaysphotos@discussions.microsoft.com> wrote in message
news:5C73B105-BE2D-4335-8FC7-9728C5260A09@microsoft.com...
> Bob,
>
> Thanks for the help. Maybe I don't understand should I type just as you
> have or do I make changes. It might be easier if I was able to get you a
> screen shot contact jaysphotos@same .com
>
> "Bob Phillips" wrote:
>
> > Summarised?
> >
> > =SUMPRODUCT(N(INDIRECT(ROW(INDIRECT("1:31"))&"!A1")))
> >
> > or just referenced
> >
> > =INDIRECT(COLUMN()&"!A1")
> >
> > etc.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "jaysphotos" <jaysphotos@discussions.microsoft.com> wrote in message
> > news:1F55B470-99DF-42DD-BB17-F0ED77269F55@microsoft.com...
> > > Here is what I'm trying to do. I have a woorkbook with 32 sheets in
it 31
> > of
> > > them are the same and will be as days of the month, the last sheet is
used
> > to
> > > track commisions. I would like to be able to automate the process to
move
> > > the sold information from 5 different cells, meaning if there is
anything
> > in
> > > those cells move the name information to the commision page. Please
help!
> >
> >
> >