Find an average date

[Christy]

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

 

[T. Valko]

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

 

[Pete_UK]

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