Countifs with Column Formulas
I need a formula that will count if a course is completed and the month, for example
=COUNTIFS(Month:Month, ="October", Status:Status, ="completed")
This is returning the correct information.
But, I am using a column formula for the Month and the COUNTIFS formula only works if the column formula is removed. Once I convert the Month column back to a column formula the above formula no longer works. I tried adding an IFERROR, but that didn't work either. Any suggestions?
Help Article Resources
Check out the Formula Handbook template!