Return an average date
If you're getting #DIV/0! then that means there are no entries in column H
that meet the criteria. Try this array formula** :
=IF(SUM(COUNTIF(H13:H36,{"in","ti"})),ROUND(AVERAG E(IF(H13:H36={"in","ti"},E13:E36)),0),"")
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
If there are no dates in column E then the result will be 0 (formatted as
date will display as 1/0/1900)
--
Biff
Microsoft Excel MVP
"Christy" wrote in message
...
How would I alter this using ROUND? Also, when cells are blank I would
like
it if the cell that contained this formula didn't say #DID/O! but was just
blank.
Thanks.
"T. Valko" wrote:
=INT(AVERAGE(IF((H13:H36={"in","ti"}),E13:E36)))
Using ROUND would be more accurate.
--
Biff
Microsoft Excel MVP
"Teethless mama" wrote in
message
...
=INT(AVERAGE(IF((H13:H36={"in","ti"}),E13:E36)))
ctrl+shift+enter, not just enter
"Christy" wrote:
I'm trying to do the following:
Col E Col H
9/17/08 in
9/18/08 ti
9/19/08 ot
When H13:H36 = in and H13:H36 = ti, Then return the average date from
E13:E36.
Thanks in advance for any help.
Christy
|