RichardMGreen
Well-known Member
- Joined
- Feb 20, 2006
- Messages
- 2,177
Afternoon folks
Hopefully a nice simple question.
I havea list of values that I need to work averages out for. Unfortunately, sometimes the values will be a zero and these should be ignored.
I can work out the averages easily enough using the average function, but can't quite figure out a way of ignoring the zeros. Sample data would be :-
week 1 - 3.42
week 2 - 0 (zero)
Using the standard average function, I get an average of 1.71 when I actually want it to have an average of 3.42.
Anyone any ideas? I would prefer a function for this but would settle for a macro even though it would increase the program run-time.
Cheers
Richard
Hopefully a nice simple question.
I havea list of values that I need to work averages out for. Unfortunately, sometimes the values will be a zero and these should be ignored.
I can work out the averages easily enough using the average function, but can't quite figure out a way of ignoring the zeros. Sample data would be :-
week 1 - 3.42
week 2 - 0 (zero)
Using the standard average function, I get an average of 1.71 when I actually want it to have an average of 3.42.
Anyone any ideas? I would prefer a function for this but would settle for a macro even though it would increase the program run-time.
Cheers
Richard