Ok, it pays to plod further before posting. I got Tony's method to work,
where my problem lay, was in the naming of the worksheet. I had renamed the
first page 2000 Ranger, and that apparently was an invalid reference. I
changed it back to sheet1 and What Tony suggested worked just fine.
Thanks again....I may just have to try a Pivot table....
Brad Loomis
Hi Tony and Jim,
I Tried "Consolidate" from the data menu, and since I am unable to figure
out the proper way to enter the references to the cells, I went to Tony's
method. What happens is on my second worksheet, I have a row named Average
Miles Driven in A1. I highlight A2, go to the formula bar, enter
=Average( go to the first sheet, highlight C3 through C100 (just to
have a range of cells even though there are only 16 entries) the
highlighting makes the for lack of a better description, blinking highlight
box around the range, I go back to sheet2, that range is automatically
entered in the formula bar, I add the closing ) and in A2 cell I get the
error, #DIV/0! What am I missing. Obviously if I can get one done I can do
all the other entries I have on sheet 2.
A Pivot table looks way to complicated for me at this time or maybe any
other time for that matter.
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://nospin.com/pc/pcsoft.html
|