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(IF(C1:C100gt;0,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)
quot;Jokerquot; gt; wrote in message
news
gt; I'm looking for a formula to find the average of numbers in a column that
are
gt; greater than 0. For example, in column A, there are reaction times. In
column
gt; B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM.
In
gt; cell C1, I have the formula =B1-A1 to give me the amount of time in
between
gt; B1 and A1. The formula is copied down the column giving the cells the
value
gt; of 0. I need to find the average final times but without the 0 values. Any
gt; help would be greatly appreciated. Thank you
Thank you Bob. That works great.
quot;Bob Phillipsquot; wrote:
gt; =AVERAGE(IF(C1:C100gt;0,C1:C100))
gt;
gt; which is an array formula, it should be committed with Ctrl-Shift-Enter, not
gt; just Enter.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Jokerquot; gt; wrote in message
gt; news
gt; gt; I'm looking for a formula to find the average of numbers in a column that
gt; are
gt; gt; greater than 0. For example, in column A, there are reaction times. In
gt; column
gt; gt; B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM.
gt; In
gt; gt; cell C1, I have the formula =B1-A1 to give me the amount of time in
gt; between
gt; gt; B1 and A1. The formula is copied down the column giving the cells the
gt; value
gt; gt; of 0. I need to find the average final times but without the 0 values. Any
gt; gt; help would be greatly appreciated. Thank you
gt;
gt;
gt;
For a non-array formula, you can use..........
=SUMIF(C:C,quot;gt;0quot;)/COUNTIF(C:C,quot;gt;0quot;)Vaya con Dios,
Chuck, CABGx3
quot;Jokerquot; wrote:
gt; I'm looking for a formula to find the average of numbers in a column that are
gt; greater than 0. For example, in column A, there are reaction times. In column
gt; B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In
gt; cell C1, I have the formula =B1-A1 to give me the amount of time in between
gt; B1 and A1. The formula is copied down the column giving the cells the value
gt; of 0. I need to find the average final times but without the 0 values. Any
gt; help would be greatly appreciated. Thank you
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(IF(C1:C100gt;0,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)
quot;Jokerquot; gt; wrote in message
news
gt; I'm looking for a formula to find the average of numbers in a column that
are
gt; greater than 0. For example, in column A, there are reaction times. In
column
gt; B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM.
In
gt; cell C1, I have the formula =B1-A1 to give me the amount of time in
between
gt; B1 and A1. The formula is copied down the column giving the cells the
value
gt; of 0. I need to find the average final times but without the 0 values. Any
gt; help would be greatly appreciated. Thank you
Thank you Bob. That works great.
quot;Bob Phillipsquot; wrote:
gt; =AVERAGE(IF(C1:C100gt;0,C1:C100))
gt;
gt; which is an array formula, it should be committed with Ctrl-Shift-Enter, not
gt; just Enter.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Jokerquot; gt; wrote in message
gt; news
gt; gt; I'm looking for a formula to find the average of numbers in a column that
gt; are
gt; gt; greater than 0. For example, in column A, there are reaction times. In
gt; column
gt; gt; B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM.
gt; In
gt; gt; cell C1, I have the formula =B1-A1 to give me the amount of time in
gt; between
gt; gt; B1 and A1. The formula is copied down the column giving the cells the
gt; value
gt; gt; of 0. I need to find the average final times but without the 0 values. Any
gt; gt; help would be greatly appreciated. Thank you
gt;
gt;
gt;
For a non-array formula, you can use..........
=SUMIF(C:C,quot;gt;0quot;)/COUNTIF(C:C,quot;gt;0quot;)Vaya con Dios,
Chuck, CABGx3
quot;Jokerquot; wrote:
gt; I'm looking for a formula to find the average of numbers in a column that are
gt; greater than 0. For example, in column A, there are reaction times. In column
gt; B, there are final times. Say cell A1 is 3:25 AM and cell B1 is 3:45 AM. In
gt; cell C1, I have the formula =B1-A1 to give me the amount of time in between
gt; B1 and A1. The formula is copied down the column giving the cells the value
gt; of 0. I need to find the average final times but without the 0 values. Any
gt; help would be greatly appreciated. Thank you
