formula for daily count

formula for daily count

I'm looking to count how many times "blank" occurs in the status column per date. Entries are made daily and some days have multiple entries. I would like to set up a way to get a count of number of entries per day.

Answers

  • also, i want this formula to appear in sheet summary

  • =COUNTIFS(Status:Status, "Blank", Date:Date, TODAY())


    I found the answer... can't remove this tho

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    Glad you solved it!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.