| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate MIN excluding zero
I am trying to calculate the MIN of several non-consecutive columns, but want the calculation to ignore columns that have no value or zero (0) in them. The columns being queried have calculations of their own in them, but hopefully that isn't part of the problem. Anyway, the calculation I am using is =MIN(G291,I291,K291,M291), which will return a zero/null value if one of the cells is empty. I did a search and MSFT tells me I should use =MIN(A1:A100,A1:A10), which doesn't work for me. Suggestions? -- gezuvor ------------------------------------------------------------------------ gezuvor's Profile: http://www.excelforum.com/member.php...o&userid=30383 View this thread: http://www.excelforum.com/showthread...hreadid=513898 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Calculate Hours and overtime by week | Excel Worksheet Functions | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Threaded Mode
