LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default Eye-sight and errors

Hello All!

I've been a bit frustrated for a while since a slowly varying running
average did not look right. The formula looked OK but I checked the
value directly by summing and dividing and it did not agree. Careful
examination of my average formula revealed that instead of
AVERAGE(B11:B20), I had AVERAGE(B10,B20) : comma instead of colon. No
formula error but not what I wanted! The frustrations of ageing.

--


James Silverton
Potomac, Maryland

Email, with obvious alterations:
not.jim.silverton.at.verizon.not

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
my cursor scrolls off the bottom out of sight. MartonMan Excel Discussion (Misc queries) 1 January 9th 08 03:15 PM
Sight Lines bart972 Excel Discussion (Misc queries) 2 September 12th 07 06:20 PM
I changed my spreadsheet fix upper rows in sight how back? Mike Excel Worksheet Functions 3 April 27th 07 04:10 PM
Excel Throwing Circular Errors When No Errors Exist MDW Excel Worksheet Functions 1 August 10th 06 02:15 PM
spreadsheet on web sight Polarbear Excel Discussion (Misc queries) 0 July 5th 06 03:48 AM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"