Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average greater than 0
I'm looking for a formula to find the average of numbers in a column that are
greater than 0. For example, in column A, there are reaction times. In column B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In cell C1, I have the formula =B1-A1 to give me the amount of time in between B1 and A1. The formula is copied down the column giving the cells the value of 0. I need to find the average final times but without the 0 values. Any help would be greatly appreciated. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average greater than 0
=AVERAGE(IF(C1:C1000,C1:C100))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Joker" wrote in message ... I'm looking for a formula to find the average of numbers in a column that are greater than 0. For example, in column A, there are reaction times. In column B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In cell C1, I have the formula =B1-A1 to give me the amount of time in between B1 and A1. The formula is copied down the column giving the cells the value of 0. I need to find the average final times but without the 0 values. Any help would be greatly appreciated. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average greater than 0
Thank you Bob. That works great.
"Bob Phillips" wrote: =AVERAGE(IF(C1:C1000,C1:C100)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Joker" wrote in message ... I'm looking for a formula to find the average of numbers in a column that are greater than 0. For example, in column A, there are reaction times. In column B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In cell C1, I have the formula =B1-A1 to give me the amount of time in between B1 and A1. The formula is copied down the column giving the cells the value of 0. I need to find the average final times but without the 0 values. Any help would be greatly appreciated. Thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average greater than 0
For a non-array formula, you can use..........
=SUMIF(C:C,"0")/COUNTIF(C:C,"0") Vaya con Dios, Chuck, CABGx3 "Joker" wrote: I'm looking for a formula to find the average of numbers in a column that are greater than 0. For example, in column A, there are reaction times. In column B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In cell C1, I have the formula =B1-A1 to give me the amount of time in between B1 and A1. The formula is copied down the column giving the cells the value of 0. I need to find the average final times but without the 0 values. Any help would be greatly appreciated. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Values from an Array | Excel Worksheet Functions | |||
Average If Adejecent Cells Greater Than Zero | Excel Worksheet Functions | |||
Countif cell greater than average | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions |