Thread: Minimum formula the excludes zeros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Minimum formula the excludes zeros
current formula =min(a5:a35)

Try something like:
=MIN(IF(A5:A350,A5:A35))
Array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joco" wrote:
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
Reply With QuoteReply With Quote