I'm lost on this one Chip.

What's wrong with

=SUMPRODUCT(--(WEEKDAY(A1:A30)=6))

the only day it has a problem with is Sat if there are blanks, and that can
be avoided with

=SUMPRODUCT(--(A1:A30<""),--(WEEKDAY(A1:A30)=7))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chip Pearson" wrote in message
...
Use the following array formula:
=SUMPRODUCT(IF(A1:A30="",0,--(WEEKDAY(A1:A30)=6)))

Since this is an array formula, you must press CTRL+SHIFT+ENTER
rather than just Enter when you first enter the formula and
whenever you edit it later. If you do this properly, Excel will
enclose the formula in curly braces {}. Adjust the range A1:A30
to the range of your data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mmartens12" <u24614@uwe wrote in message
news:63e4505820d6f@uwe...
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