Feb 01 2021 09:35 AM
Hi Excel Guru's,
How do I count up the number of cells, in a column, based on dates and a specific word? I want to count up how many reports are ISSUED each month, starting in January 2020 through until December 2020.
What is the simplest way to do this? I have attached an example of what I am trying to do. Maybe countifs isn't the most appropriate formula.
Any help would be greatly appreciated.
Thanks,
Eddy
Feb 01 2021 11:23 AM
Your table is, to be blunt, something of a mess. If there were good dates in the first column (in each row) a simple Pivot Table could count the various actions by month. And it would do it easily.
COUNTIF could do the same, but also would require clean data. That's where you need to begin.
Feb 01 2021 11:36 AM