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

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

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