Minimum formula the excludes zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My column contains formulars that total weekly share prices, this shows zeros
because that weeks prices are still to be entered, or the week is a future
week.
I require a fomular that shows the minimum total, excluding the zeros.

current formula =min(a5:a35)

Thanks for any help
Joco
 
current formula =min(a5:a35)

Try something like:
=MIN(IF(A5:A35>0,A5:A35))
Array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
 
Max thanks formula works great.
Would quite like to be in Singapore right now, weather in London is not good
thanks again Joco
 
Good to hear that !
Hope I've sent some Singapore "sunshine" to you over there <g>
 
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

Minimum array formula. 5
Help! Minimum Excluding zeros across multiple sheets 5
Divide by the minimum non-zero number in a range of cells 21
Using Min Formula with Multiple Criteria Excluding Zeros 5
Minimum without zeros or negatives 3
Finding Min Cell values excluding zero in alternate columns 9
zero value in cell 2
Averaging, but excluding zeros 5

Back
Top