Help with creating a formula

[Guest]

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 Phillips]

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)

 

[Guest]

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]

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)