Home |
Search |
Today's Posts |
#1
|
|||
|
|||
having 0 as a min when running mina or average
Hi I am trying to simplify my spreadsheets, and would like a minimum column.
I can not find out how to not include cells with 0 in. Same as when doing an average for a row of months, I would also not like to count months with 0 . Thanks Tim |
#2
|
|||
|
|||
=MIN(IF(A2:A100<0,A2:A100))
=AVERAGE(IF(A2:A100<0,A2:A100)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Tim" wrote in message ... Hi I am trying to simplify my spreadsheets, and would like a minimum column. I can not find out how to not include cells with 0 in. Same as when doing an average for a row of months, I would also not like to count months with 0 . Thanks Tim |
#3
|
|||
|
|||
Thanks for this amazingly fast reply.
"Peo Sjoblom" wrote in message ... =MIN(IF(A2:A100<0,A2:A100)) =AVERAGE(IF(A2:A100<0,A2:A100)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Tim" wrote in message ... Hi I am trying to simplify my spreadsheets, and would like a minimum column. I can not find out how to not include cells with 0 in. Same as when doing an average for a row of months, I would also not like to count months with 0 . Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Pivot table (Running Averages) | Excel Worksheet Functions | |||
Plotting moving average line on a chart | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
average, array and offsets | Excel Worksheet Functions |