Thread: Divide by the minimum non-zero number in a range of cells
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_9_] barry houdini[_9_] is offline
external usenet poster
  
Posts: 1
Default Divide by the minimum non-zero number in a range of cells

Shane Devenshire;380163 Wrote:
If you don't want an array formula try this

=SUMPRODUCT((A1:A7<0)*(MIN(A1:A7)=A1:A7)*A1:A7)

Surely that won't always return the correct result? If all cells A1:A7
contain the number 1 then that formula will give you 7


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106326

Reply With QuoteReply With Quote