Help with sheet summary formula for count if month/year
I essentially need to do a summary count by month. I am trying to get a summary formula to count if the column equals a particular month/year combination. I have already created the needed helper formula to display the month and year combo. But the summary formula yields an Invalid Data Type error. Screenshot of the helper column below. I am trying to do a summary count by month and year. Count if Live Date Helper = 2023/01 (Jan 2023). And the next summary formula field would be Count If Live Date Helper = 2023/02 (Feb 2023). Here is the formula I am attempting for Jan: =COUNTIF([Live Date Helper]:[Live Date Helper], "2023/01"). If I remove the brackets I just get an unparseable error. Please help me figure out what I am doing wrong.
Help Article Resources
Check out the Formula Handbook template!