Average Time

H

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,
 
H

Howard

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


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

Regards,
Fred

Howard said:
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,

.
 
H

Howard

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


מיכ×ל (מיקי) ×בידן said:
{=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 said:
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,
 
R

Reeza

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



מיכ×ל (מיקי) ×בידן said:
{=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:D)/COUNTIF(B:B, "MONDAY")
 
H

Howard

Thanks very much.
--
Howard


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



מיכ×ל (מיקי) ×בידן said:
{=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?

- Show quoted text -

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

Fred Smith

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

Regards,
Fred

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


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

Regards,
Fred

Howard said:
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,

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top