Averages ignoring zeros

ctomblin

New Member
Joined
Apr 25, 2002
Messages
49
I need to calculate "average number of loads per day" for any given number of days. ie. over a 7 day period I only want the average calculated against active days. For example if production only takes place on 3 of the 7 days then the average should be calculated against 3 days not 7.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

elgringo56

Well-known Member
Joined
Apr 15, 2002
Messages
869
If you have values in say, A1 down thru A7, but some of the cells in that area are blank, no entries, =AVERAGE(A1:A7) will only look at the cells that have values in them. So, if you take any cells that have zeros in them and make them blank ("") instead of zero, you will only average the cells with numbers.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,948
Members
412,299
Latest member
agentless
Top