Is this what you are looking for?

=SUMIF(A2:A200,"Monday",B2:B200)/COUNTIF(A2:A200,"Monday")

--
Rick (MVP - Excel)


"Toast" wrote in message
...
Column A has dates, and column B has sales figures for the respective
dates.

I'm trying to use =SUMIF to add together all the "Mondays" and the rest of
the days of the week, and =COUNTIF to count the number of "Mondays" so
that I
can get a value that tells me how much each day's average is
approximately.
I've gotten this far, then got stuck because I have no idea what to do:

=SUMIF(A2:A200,"Monday",B2:B200)

Your help's appreciated ahead of time :)