Use ROUND to return an average date

[Christy]

Does anyone know how I would alter this using ROUND? Also, when cells in Col
H and/or Col E are blank I would like it if the cell that contained this
formula didn't say #DID/O! but was just blank.
Thanks.

=INT(AVERAGE(IF((H13:H36={"in","ti"}),E13:E36)))

This is what I'm trying to do.....
Col E Col H
9/17/08 in
9/18/08 ti
9/19/08 ot
When H13:H36 = in OR H13:H36 = ti, Then return the average date from
E13:E36 when there is an average date but blank when cells in Col H & E are
blank.

Thanks in advance for any help.
Christy

 

[Peo Sjoblom]

=ROUND(AVERAGE(IF((H13:H36={"in","ti"}),E13:E36)),0)

--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

Oops! To fix the DIV errors

=IF(COUNT(E13:E15)=3,ROUND(AVERAGE(IF((H13:H36={"in","ti"}),E13:E36)),0),"")

--


Regards,


Peo Sjoblom

 

[T. Valko]

See your other post

 

[Peo Sjoblom]

There is apparently a third post as well

--


Regards,


Peo Sjoblom

 

[T. Valko]

I haven't made it that far!

 

[NoodNutt]

G'day Christy

This works as I have tested

Assumed you have 3 seperate column heading IN, TI, & OT

A B C
1 IN TI OT
2


A2 =SUMPRODUCT(AVERAGE(--($H13:$H36="IN"),$E13:$36))
B2 =SUMPRODUCT(AVERAGE(--($H13:$H36="TI"),$E13:$36))
C2 =SUMPRODUCT(AVERAGE(--($H13:$H36="OT"),$E13:$36))

HTH
Mark.