having 0 as a min when running mina or average

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
=MIN(IF(A2:A100<>0,A2:A100))


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



entered with ctrl + shift & enter
 
Thanks for this amazingly fast reply.

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


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



entered with ctrl + shift & enter
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Average of time spent monthly getting DIV/0 error 2
Average function 5
Average of time each month 3
Average of Subtotals in Pivot Table 0
Excel Average dates help 0
Average with #DIV/0! 4
Average cells with #DIV/0! 4

Back
Top