| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pass The Formulas Please
I have a worksheet set up for one year's weekly income, expenses, etc. Cell "A-1" represents the first week's income. Cell "A-2" represents the second week's income, on to "A-52" 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 "Average" weekly Income, another showing the week with the maximum income. I'd like a cell to show the "Minimum" 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: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=511564 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pass The Formulas Please
Try this array formula
=MIN(IF(A1:A520,A1:A52)) entered using Ctrl+Shift+Enter HTH Jean-Guy "lsmft" wrote: I have a worksheet set up for one year's weekly income, expenses, etc. Cell "A-1" represents the first week's income. Cell "A-2" represents the second week's income, on to "A-52" 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 "Average" weekly Income, another showing the week with the maximum income. I'd like a cell to show the "Minimum" 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: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=511564 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pass The Formulas Please
=min(if(a1:a52<0,a1:a52)) confirm with control+shift+enter -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=511564 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pass The Formulas Please
YES-YES-YES !!!!!!!! Thanks a whole lot, much appreciated!! -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=511564 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
| Countif formulas change after doing a sort | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
