Average If greater then )%

D

deann1584

Is it possible to have an average for a column of percentages onl
including percentages greater then zero
 
F

Frank Kabel

Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=AVERAGE(IF(A1:A100>0,A1:A100))
 
Top