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