Average Time

[Howard]

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,

 

[Fred Smith]

If you're using Excel 2007, use:
=averageif(B:B,"Monday",D)

Regards,
Fred

 

[Howard]

We're using Excel 2003, but thanks for the response.
--
Howard

If you're using Excel 2007, use:
=averageif(B:B,"Monday",D)

Regards,
Fred

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]

Thanks, that worked. Is there any way to reference the whole column. B:B does
not work.
--
Howard

{=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

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,

 

[Reeza]

Thanks, that worked. Is there any way to reference the whole column. B:B does
not work.
--
Howard

{=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

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,

- Show quoted text -

=SUMIF(B:B, "MONDAY", D)/COUNTIF(B:B, "MONDAY")

 

[Howard]

Thanks very much.
--
Howard

Thanks, that worked. Is there any way to reference the whole column. B:B does
not work.
--
Howard

{=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,

- Show quoted text -

=SUMIF(B:B, "MONDAY", D)/COUNTIF(B:B, "MONDAY")
.

 

[Fred Smith]

You would have saved us both a lot of time by mentioning this from the
start.

Regards,
Fred

We're using Excel 2003, but thanks for the response.
--
Howard

If you're using Excel 2007, use:
=averageif(B:B,"Monday",D)

Regards,
Fred

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,

.