Oops! To fix the DIV errors

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

--


Regards,


Peo Sjoblom

"Peo Sjoblom" wrote in message
...
=ROUND(AVERAGE(IF((H13:H36={"in","ti"}),E13:E36)), 0)

--


Regards,


Peo Sjoblom

"Christy" wrote in message
...
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