Countifs to give YTD sales units

[kellylet]

I have this formula working on an older version of this report: COUNTIFS(Transactions[Year],B$2,Transactions[Mo No],"<="&MONTH(B$3&" 1")).

I have copied and pasted it into a new but similar project: COUNTIFS(Table1[Year],C$3,Table1[Month],"<="&MONTH(C$4&"1")) I am getting back a 0 result. Cell C3 is 2022 and C4 is February. I think the red text is the issue and yet I cannot find an answer online to calculate units sold year to date. I tried changing Feb to month "2" but that also did not work.

My monthly unit countif formula is working and giving me 16 units in Feb. COUNTIFS(Table1[General Status],"CL", Table1[Year],$C$3,Table1[Month],C$4)

I put a snip below of what I am working on. Any help is appreciated! Thanks.

 

[awoohaw]

Hi @kellylet , Welcome to the forum.
is it possible you can post the source data that is in the countifs formula? The xl2bb add in is great for posting mini workbooks, and helps the forum help you.
In a worst case you could post the data as a table. Images are more often than not never helpful.

I (and i'm sure others) look forward to helping you.

 

[kellylet]

Thanks. I tried to get the mini-sheet to upload but my only result was the rainbow wheel of death. I'll keep trying.

 

[awoohaw]

the forum can't do much without any data. Where is Table1? Please post as a table if you cannot get the xl2bb add in working. Images do not help much.