Averaging to-date lists???
Hello,
I am trying to average this months list of numbers to-date from the first of the month until now. Since there are no entries in the future cells they are returned as zeros. The average function takes the full month and averages all the numbers in the month, including the zeros values. Is it possible to average the numbers to-date, or do I need to change the future cell values to "no value" IF functions? In either case, does anyone have an example of the equation? Thanks, Paul |
Averaging to-date lists???
Just outsort the 0
=AVERAGE(IF(rng<0,rng)) which is an array formula, commit with Ctrl-Shift-Enter -- __________________________________ HTH Bob "pjroethel" wrote in message ... Hello, I am trying to average this months list of numbers to-date from the first of the month until now. Since there are no entries in the future cells they are returned as zeros. The average function takes the full month and averages all the numbers in the month, including the zeros values. Is it possible to average the numbers to-date, or do I need to change the future cell values to "no value" IF functions? In either case, does anyone have an example of the equation? Thanks, Paul |
All times are GMT +1. The time now is 01:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com