From: Howard on 5 May 2010 22:22 Thanks very much. -- Howard "Reeza" wrote: > 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") > . > From: Fred Smith on 5 May 2010 23:58 You would have saved us both a lot of time by mentioning this from the start. Regards, Fred "Howard" wrote in message news:42D26621-F4D8-48A0-A76A-2C1B6794EAAE(a)microsoft.com...> 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 >> >> . >> First  |  Prev  |  Pages: 1 2 Prev: Data validationNext: Sorting Columns by number of characters