I’m tracking time spent on different things in a given month, here is the table.
Lets say I want to count up how many times I spent time on a in February.
I tried it with this …
… and …
… but it didn’t work.
basically I’m trying to figure out how to display a range of dates for example from 2022-01-31 to 2022-03-01 so it can lets say, count up the times of a
The output of the countifs function should be 14, because an "a" appears 14 time in the span of 2022-01-31 to 2022-03-1
You need to separate the date portion into two separate count and criterias ranges (one for the lower range and one for the upper).
Answered By – Kevin
Answer Checked By – Mildred Charles (BugsFixing Admin)