Reference cell values from other sheets in a function

[Mike]

I am trying to do something that seems like it would be quite simple, and yet
I cannot get it to work. I have some data in separate work sheets (one sheet
for each month), and a yearly summary sheet. I have a DAVERAGE function in
each month. I am trying to take that DAVERAGE on each monthly sheet and make
an AVERAGE function in the year summary page referencing each DAVERAGE cell
on the monthly sheets. I enter =AVERAGE( into the cell and click over to
the other sheets where I need to pull the info from. I click on the DAVERAGE
cell that I need to reference in the yearly AVERAGE function and nothing is
referenced but the sheet I am currently on. If I click on a cell with just a
number keyed into it, it will pull that info to the AVERAGE function on my
yearly sheet, but never the info from the DAVERAGE cell. Any assistance
would be greatly appreciated.

 

[Jim Rech]

I can't duplicate the problem. Try clicking on a nearby cell (to the
DAVERAGE) and use the cursor keys to move to the DAVERAGE cell. Then press
"," to do more cells or ")" to finish the entry.

--
Jim
|I am trying to do something that seems like it would be quite simple, and
yet
| I cannot get it to work. I have some data in separate work sheets (one
sheet
| for each month), and a yearly summary sheet. I have a DAVERAGE function
in
| each month. I am trying to take that DAVERAGE on each monthly sheet and
make
| an AVERAGE function in the year summary page referencing each DAVERAGE
cell
| on the monthly sheets. I enter =AVERAGE( into the cell and click over to
| the other sheets where I need to pull the info from. I click on the
DAVERAGE
| cell that I need to reference in the yearly AVERAGE function and nothing
is
| referenced but the sheet I am currently on. If I click on a cell with
just a
| number keyed into it, it will pull that info to the AVERAGE function on my
| yearly sheet, but never the info from the DAVERAGE cell. Any assistance
| would be greatly appreciated.
| --
| Mike

 

[Mike]

Thanks for your reply. I just tried it and it didn't work. I then entered
the cell addresses by hand and it worked. I appreciate your assistance.