having 0 as a min when running mina or average
 

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

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


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



entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom


"Tim" wrote in message
...
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

Thanks for this amazingly fast reply.

"Peo Sjoblom" wrote in message
...
=MIN(IF(A2:A100<0,A2:A100))


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



entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom


"Tim" wrote in message
...
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