I want to set up a count of all cells where the date is equal to the date
specified in column A on the sheet and the font for the specified range is
Red.

Currently my formula reads
=SUMPRODUCT(('Master Log'!U$2:U$2600="Red")*('Master Log'!U$2:U$2600=A11))

I need to find out how many cases I processed that were overdue by date so I
can see how many cases I had overdue per month.

The font on the Master Log goes to Red in the conditional formatting if the
item was processed overdue.

Any assistance is greatly appreciated.