having 0 as a min when running mina or average

T

Tim

Hi I am trying to simplify my spreadsheets, and would like a minimum column.
I can not find out how to not include cells with 0 in.

Same as when doing an average for a row of months, I would also not like to
count months with 0 .

Thanks Tim
 
P

Peo Sjoblom

=MIN(IF(A2:A100<>0,A2:A100))


=AVERAGE(IF(A2:A100<>0,A2:A100))



entered with ctrl + shift & enter
 
Top