Hello Community!
I have a COUNTIFS formula that does not return an error, but it also does not return the result I am expecting. Long story short, I am trying to count how many projects we plan to start by month and year. There are three separate columns that I am pulling from. The column that is giving me troubles is the Year. It does not seem to matter if I put in a static number or a cell reference, it will not count. If I take the year out of the equation, it works fine.
I have included a screen shot that outlines what my data looks like and my formulas. I wondered if it has to do with the formula I am using to pull out the year information, but I am using the same thing for month with no issue. Any ideas on what could be causing the return of zero would be greatly appreciated.
Thanks!
Sara
