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...
You could also try this in H57 and copy down.
=SUMPRODUCT(--(TEXT($G$2:$G$255,"mmyy")=TEXT(F257,"mmyy")),--($H$2:$H$255="Issued"))
=SUMPRODUCT(--(TEXT($G$2:$G$255,"mmyy")=TEXT(F257,"mmyy")),--($H$2:$H$255="Issued"))