Hi all,
I'm looking for a countif formulae that will that will look only within a certain range of dates, for cells that contain a certain text.
I have a massive spreadsheet tracking data from the past 4 years and into the future.
I have one column (Column M) of dates, I want to only look at data between 1 Oct 2020 - 31 Dec 2020.
I have a different column (Column O) that contains text "On Time", "Late".
So, I want to count the number of "On Time" between 1 Oct 2020 and 31 Dec 2020.
Any help is appreciated.
Bookmarks