Using Countif to calculate the number of days in a column

I am trying to use the following formula to count the number of times a day appears in a column. It doesn't seem to be working the way I want it to.

=COUNTIF($A13:$A200,"Sunday")

It could be the way the days of the week are gathered on the sheet, you can see the attached workbook to see how I am using it.

thanks for any help with this.

Nick

=sumproduct(--(weekday(a1:a20,1)=1))

Hi,

In F1,and copied down:

=SUMPRODUCT((TEXT($A$13:$A$100,"dddd")=E5)*1)

Or this one (array entered)

Please Login or Register  to view this content.