Counting the incidents that occur on a specific day of the week

[HeRoseInThree]

I am using =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=1)) to count the incidents that occur on a Sunday and =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=2)) for Monday and so on. They are working great, except for Saturday =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=7)). I am getting a value that is 9000+ higher than expected.

Accident Register.xlsx
	J	K	L	M	N	O	P
1	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
2	1	9	11	5	7	7	9955
ALL

Cell Formulas
Range	Formula
J2	J2	=SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=1))
K2	K2	=SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=2))
L2	L2	=SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=3))
M2	M2	=SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=4))
N2	N2	=SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=5))
O2	O2	=SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=6))
P2	P2	=SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=7))

 

[Fluff]

Any blank cells will will be treated as a Saturday, how about

=SUMPRODUCT((A$5:A$9999<>"")*(WEEKDAY(A$5:A$9999)=7))

 

[HeRoseInThree]

Thanks SO much!!

 

[Fluff]

You're welcome & thanks for the feedback.