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
Bookmarks