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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com