=SUMPRODUCT(--(A2:A20="Monday"),--(B2:B20="STOPS"))

if the days are textual, i.e. not real dates. If they are real dates use

=SUMPRODUCT(--(Weekday(A2:A20)=2),--(B2:B20="STOPS"))

--
HTH

Bob Phillips

"moglione1" wrote
in message ...

Does anybody know if I can count the number of "STOPS" in one column fr
a particular day of the week in another column.

E.g. I want to count how many "STOPS" occur on a "MONDAY"


--
moglione1
------------------------------------------------------------------------
moglione1's Profile:
http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=470141