software

I have a worksheet set up for one year's weekly income, expenses, etc.
Cell quot;A-1quot; represents the first week's income.
Cell quot;A-2quot; represents the second week's income, on to quot;A-52quot; etc. All
weeks not yet come have zeros already programmed in their cells.
At the top of this column, I have a cell showing the Total YTD income,
another cell showing quot;Averagequot; weekly Income, another showing the week
with the maximum income. I'd like a cell to show the quot;Minimumquot; weekly
income for the year but all of the zeros below the last week's income
won't allow anything but $0.00 in the minimum cell. Is there a formula
similar to =min(...) that will not consider the zeros?--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=511564Try this array formula

=MIN(IF(A1:A52gt;0,A1:A52))
entered using Ctrl Shift Enter

HTH
Jean-Guy

quot;lsmftquot; wrote:

gt;
gt; I have a worksheet set up for one year's weekly income, expenses, etc.
gt; Cell quot;A-1quot; represents the first week's income.
gt; Cell quot;A-2quot; represents the second week's income, on to quot;A-52quot; etc. All
gt; weeks not yet come have zeros already programmed in their cells.
gt; At the top of this column, I have a cell showing the Total YTD income,
gt; another cell showing quot;Averagequot; weekly Income, another showing the week
gt; with the maximum income. I'd like a cell to show the quot;Minimumquot; weekly
gt; income for the year but all of the zeros below the last week's income
gt; won't allow anything but $0.00 in the minimum cell. Is there a formula
gt; similar to =min(...) that will not consider the zeros?
gt;
gt;
gt; --
gt; lsmft
gt; ------------------------------------------------------------------------
gt; lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
gt; View this thread: www.excelforum.com/showthread...hreadid=511564
gt;
gt;


=min(if(a1:a52lt;gt;0,a1:a52))

confirm with control shift enter--
duane------------------------------------------------------------------------
duane's Profile: www.excelforum.com/member.php...oamp;userid=11624
View this thread: www.excelforum.com/showthread...hreadid=511564
YES-YES-YES !!!!!!!!
Thanks a whole lot, much appreciated!!--
lsmft
------------------------------------------------------------------------
lsmft's Profile: www.excelforum.com/member.php...oamp;userid=30678
View this thread: www.excelforum.com/showthread...hreadid=511564