That suggest you matched none.

Is the day column a day, or a date formatted to show just the day?

--
__________________________________
HTH

Bob

"Jarod" wrote in message
...
Thanks, I tried it, changed $CA$500 to $C$500, but still got #DIV/0 error.
I
did use the CTRL-SHIFT-ENTER array commit.

"Bob Phillips" wrote:

=AVERAGE(IF(($A$2:$A$500="Monday")*($C$2:$C$500--"06:00")*($C$2:$CA$500<=--"06:30"),F2:F500))