![]() |
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