COUNTIFS Formula - Date Range and Criteria
I am trying to figure out a formula to count the number of times a specific item is on a sheet between a date range and cannot seem to get the correct answer or keep getting an error.
In an easy example below, I am trying to find a formula that will count the number of times "W" occurs between April 1, 2023 and April 30, 2023. How would I write that out? Any help would be great.
Answers
-
Hi Christine!
I would try the following:
=COUNTIFS(Name, "W", Date, ">="&DATE(2023,4,1), Date, "<="&DATE(2023,4,30))
-
That partially worked. I changed "Name" to "Task Bar" and I was good to go. Thanks so much for the help!
