Average Valid Values
Hi All:
Is there anyone who can tell me how to calculate average of valid values? I have a huge data set with 1 to 6 valid values and 0 as missing. I need to calculate average of only valid values (1 to 6) for each record but to exclude 0 (missing). For exmple, 1, 3, 3, 0, 5 The average for this record should be 3 because 0 is missing value and should not be included. But when I use Excel built in function Average, the result is 2.4. Any help will be very very appreciated. Charles |
All times are GMT +1. The time now is 02:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com