Forum Discussion
Countifs based on specific months and selected criteria
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 throug...
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.