how can i use countif to count sundays in excel

  • Thread starter Thread starter Reverend Ken
  • Start date Start date
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
 
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))
 
Back
Top