Thread: how can i use countif to count sundays in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default how can i use countif to count sundays in excel
Reverend Ken wrote:
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


=SUMPRODUCT(--(WEEKDAY(A4:A34)=1))
Reply With QuoteReply With Quote