suppose your weekdays are entered as text "Monday" and so on, then try:

=SUMPRODUCT(--(TEXT(Sheet1!A$1:A$18,"dddd")=C1))

In this case Monday is in C1 and the range A1:A18 contains Excel legal
dates.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"camp732" wrote:

I have two worksheets one is claim detail and the other is weekday. I need
to put a formula in weekday worksheet to reference in claim detail worksheet
how many claims occurred on a certain day of the week which is in one column
on the claim detail worksheet.