combined Countif and weekday function

10/13/21
Answered - Pending Review

I have a sheet which has a date field. This field is filled in with a date based on the date to which something occurred.

I have helping columns in that same sheet that extracts only the Month, Date, and weekday based on date field. With the "helping columns" on a different sheet which i'm calling "stat sheet" i'm counting how many "Sundays" represented by the number "1" there are in totality so i can graph the weekdays and month of the year.

My question is this.

On my stat sheet, is it possible to do a countif and weekday function in order to get rid of the need of using the "helping columns"

I'm using the following text, can someone please tell me what i'm doing wrong.


=COUNTIF(WEEKDAY({BPD DTU Responses Range 6}), "1")

Answers

  • Jason DuryeaJason Duryea ✭✭✭✭✭

    I was trying it with this formula, but I can only get it to return "1" for a value. I know there are bunch of matching dates in the column. Try it and see if it does the same for you.

    =COUNT(COLLECT({BPD DTU Responses Range 6}, WEEKDAY(@cell), 1))

  • I'm also getting the result of 1.

    Just to clarify my intent though, i'm not really tring to collect anyhing, in all reality there is only 1 criteria i am trying to search against.


    Using the "weeday" function from the date: =weekday(date) illustrated below I get the appropriate number using a helper field. I'm just trying to accomplish the same thing without the helping field.

    Count the number of records in the "date" column where the weekday = "1" where 1=Sunday.

    Date day of week field

    10/10/21 1

    10/10/21 1

    10/10/21 1

    10/13/21 4

Sign In or Register to comment.