Perhaps the person who told you that should explain why it can't be done.
Excel will not include blanks cells in an average, but it will include zero
values, although they can be excluded with the array formula

=AVERAGE(IF(A1:A1000,A1:A100))

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)

"Marketing analyzr" wrote in message
oups.com...
Greetings,
This is actually a basic mathmatical question but its a stumper for me.

Can you average a column of percentages and get a true average?
I've been told that it can't be done accurately but I never understood
the expanation.

thanks in advance
Marketing Analyzr