From: Howard on 5 May 2010 17:21 In column B, I have the days of the week. Monday may repeat 30 times, Tuesday 35 times etc. In column D, I have the time ([mm]:ss) for each day. How do I get the average time for Monday? Thanks, -- Howard From: Fred Smith on 5 May 2010 17:37 If you're using Excel 2007, use: =averageif(B:B,"Monday",D:D) Regards, Fred "Howard" wrote in message news:B0500892-356E-4DF1-A84B-63E55B92A42D(a)microsoft.com...> In column B, I have the days of the week. Monday may repeat 30 times, > Tuesday > 35 times etc. In column D, I have the time ([mm]:ss) for each day. > How do I get the average time for Monday? > > Thanks, > -- > Howard From: Howard on 5 May 2010 18:27 We're using Excel 2003, but thanks for the response. -- Howard "Fred Smith" wrote: > If you're using Excel 2007, use: > =averageif(B:B,"Monday",D:D) > > Regards, > Fred > > "Howard" wrote in message > news:B0500892-356E-4DF1-A84B-63E55B92A42D(a)microsoft.com... > > In column B, I have the days of the week. Monday may repeat 30 times, > > Tuesday > > 35 times etc. In column D, I have the time ([mm]:ss) for each day. > > How do I get the average time for Monday? > > > > Thanks, > > -- > > Howard > > . > From: Howard on 5 May 2010 18:32 Thanks, that worked. Is there any way to reference the whole column. B:B does not work. -- Howard "מיכאל (מיקי) אבידן" wrote: > {=AVERAGE(IF(B1:B3000="Monday",C1:C3000))} > *** Pls note ! This is an Array Formula. You should NOT type the curly braces. > In order to confirm the formula, you will use the three key combination - > while holding, down, CTRL+SHIFT press ENTER instead of just pressing ENTER. > You will be able to identify an Array Formula, in the Formula Bar, if it is > confined in a pair of curly braces. > Micky > > > "Howard" wrote: > > > In column B, I have the days of the week. Monday may repeat 30 times, Tuesday > > 35 times etc. In column D, I have the time ([mm]:ss) for each day. > > How do I get the average time for Monday? > > > > Thanks, > > -- > > Howard From: Reeza on 5 May 2010 19:24 On May 5, 3:32Â pm, Howard wrote:> Thanks, that worked. Is there any way to reference the whole column. B:B does > not work. > -- > Howard > > > > "××××× (×××§×) ×××××" wrote: > > {=AVERAGE(IF(B1:B3000="Monday",C1:C3000))} > > *** Pls note ! This is an Array Formula. You should NOT type the curly braces. > > In order to confirm the formula, you will use the three key combination - > > while holding, down, CTRL+SHIFT press ENTER instead of just pressing ENTER. > > You will be able to identify an Array Formula, in the Formula Bar, if it is > > confined in a pair of curly braces. > > Micky > > > "Howard" wrote: > > > > In column B, I have the days of the week. Monday may repeat 30 times, Tuesday > > > 35 times etc. In column D, I have the time ([mm]:ss) for each day. > > > How do I get the average time for Monday? > > > > Thanks, > > > -- > > > Howard- Hide quoted text - > > - Show quoted text - =SUMIF(B:B, "MONDAY", D:D)/COUNTIF(B:B, "MONDAY")  |  Next  |  Last Pages: 1 2 Prev: Data validationNext: Sorting Columns by number of characters