Thread
:
AVERAGE function
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
JRD
external usenet poster
Posts: 60
AVERAGE function
Can anyone tell me whether there is a way to average a whole column of
numbers but ignoring blank cells or cells with errors in
e.g.
Column A
1
2
4
5
3
5
4
DIV0!
DIV0!
3
4
blank
2
Many thanks
John
Reply With Quote
JRD
View Public Profile
Find all posts by JRD