| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find an average date
I would like to be able to do the following:
B12:B50 are all various dates, which include 2007 & 2008. F12:F50 = IN or F12:F50 = OT When Col F = IN, return the average date from B12:B50 in one cell and when Col F = OT, return the average date from B12:B50 in another cell. I've looked in the previous posts and can't find anything that works. Thanks to anyone who can help. Christy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find an average date
One way:
For IN: =IF(COUNTIF(F12:F50,"in"),ROUND(SUMIF(F12:F50,"in" ,B12:B50)/COUNTIF(F12:F50,"in"),0),"") For OT: =IF(COUNTIF(F12:F50,"ot"),ROUND(SUMIF(F12:F50,"ot" ,B12:B50)/COUNTIF(F12:F50,"ot"),0),"") Format both as DATE -- Biff Microsoft Excel MVP "Christy" wrote in message ... I would like to be able to do the following: B12:B50 are all various dates, which include 2007 & 2008. F12:F50 = IN or F12:F50 = OT When Col F = IN, return the average date from B12:B50 in one cell and when Col F = OT, return the average date from B12:B50 in another cell. I've looked in the previous posts and can't find anything that works. Thanks to anyone who can help. Christy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find an average date
You could try something like:
=SUMIF(F12:F50,"IN",B12:B50)/COUNTIF(F12:F50,"IN") and =SUMIF(F12:F50,"OT",B12:B50)/COUNTIF(F12:F50,"OT") Format the two cells as dates. Hope this helps. Pete On Aug 10, 7:44 pm, Christy wrote: I would like to be able to do the following: B12:B50 are all various dates, which include 2007 & 2008. F12:F50 = IN or F12:F50 = OT When Col F = IN, return the average date from B12:B50 in one cell and when Col F = OT, return the average date from B12:B50 in another cell. I've looked in the previous posts and can't find anything that works. Thanks to anyone who can help. Christy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| select date range then find average of values in another cell | Excel Worksheet Functions | |||
| How to find average for grading? | Excel Worksheet Functions | |||
| How do I find the average time? | Excel Worksheet Functions | |||
| Using Sumproduct to Find Average | Excel Discussion (Misc queries) | |||
Linear Mode
