Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Time
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Time
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Time
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Time
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average time | Excel Worksheet Functions | |||
Average of Day and Time | Excel Worksheet Functions | |||
Average Time | Excel Worksheet Functions | |||
average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
Average Time | Excel Worksheet Functions |