I have been trying to use SUMPRODUCT to count the number of data entries that
are less than 23 (column F) by quarter (date is in column C). I can't seem
to get it to work. I would also like to then calculate the average in a
similar fashion. i can't get it to count though. I have also tried to use
datevalue with the dates.

=SUMPRODUCT(--(Log!C2:C500<"4/1/04")*(Log!F2:F500<23)


--
Sincerely,
Tom Fortune