how can i use countif to count sundays in excel

R

Reverend Ken

I tried COUNTIF(A4:A34,WEEKDAY()=1) it returned 0 a;though there were 4
Sundays in the Month Listed. and these were in the form of WEEKDAY()=1

What am i doing wrong in entering the formula
 
G

Glenn

Reverend said:
I tried COUNTIF(A4:A34,WEEKDAY()=1) it returned 0 a;though there were 4
Sundays in the Month Listed. and these were in the form of WEEKDAY()=1

What am i doing wrong in entering the formula
Click to expand...


=SUMPRODUCT(--(WEEKDAY(A4:A34)=1))
 
Top