ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Eye-sight and errors (https://www.excelbanter.com/excel-discussion-misc-queries/195073-eye-sight-errors.html)

James Silverton[_3_]

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



All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com