formula for daily count

Ryan Murphy

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.

Ryan Murphy

also, i want this formula to appear in sheet summary

Ryan Murphy

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

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

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!