I am keeping track of how many calls i get each day. In column A i have the
date i got the call. What i want to do is add up how many calls i get on
Monday, Tuesday etc.

This is the formula i have so far, but it gives me bogus data.

=SUMPRODUCT(--(WEEKDAY(Data!$A$5:$A$500,2)=1))

What am i doing wrong?

Thanks