Thread
:
Averages excluding zeros
View Single Post
#
2
Posted to microsoft.public.excel.misc
vezerid
external usenet poster
Posts: 751
Averages excluding zeros
Jaytee,
Assuming your data are in A1:A6,
=AVERAGE(IF(A1:A6<0,A1:A6))
This is an *array* formula, hence it should be committed with
Shift+Ctrl+Enter
HTH
Kostis Vezerides
Reply With Quote
vezerid
View Public Profile
Find all posts by vezerid