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

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

Regards,
Fred

"Howard" wrote in message
...
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

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
...
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


"מיכ�ל (מיקי) �בידן" 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

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")

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")
.

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

Regards,
Fred

"Howard" wrote in message
...
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
...
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

.