COUNTIFS formula not returning result

Sara Morris

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

 

Paul Newcome

Try using @cell = 

 

in your criteria.

 

@cell = "Est Start",

@cell = "Jan"

@cell = [Lot Status]1