I have a column of values.I can average them at the bottom of the column with a formula... but the value is incorrect because it's also averaging all the 0's. Can you tell me how to get a subtotal of the cells that only have values in them? (The zeros have to be there because they are linked to another worksheet function.) I believe somewhere I may have to use absolute referencing... but I'm not certain where. Would it be sub averaging? Or am I barking up the wrong tree?Example:
38
43
77
74
42
0
0
0
0
0
Bookmarks