formula or function?

G

grok

I'd like to have a macro that will compute the average of the non-blank
elements in a column. Should I use a formula or a function for the
calculating part?
 
B

Bernard Liengme

Have you tried entering, for example:
2, blank, 3, blank, 4, blank in A1:A4 and using the formula =AVERAGE(A1:A4)
?
If you try this you will find that AVERAGE ignores blanks

Note we have a formula - it begins with =
But our formula incorporates a function - AVERAGE

best wishes
 
Top