J
James Silverton
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
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