Forum Discussion
Unable to use YEAR() and MONTH() inside COUNTIF()
I am trying to count and sum a column of numbers based on month and year. In the most simplest example, I made a blank workbook with a list of dates and then tried to count them based on month an...
I am trying to sum colum AX if column AN is equal to Month (Jan) and Year (2020) and column AL equal to certain installer name. I have tried =SUMIFS(AX7:AX, AL7:AL,B65,AN7:AN, ">="&DATE(YEAR(D61),MONTH(G613),1)) B65 is variable for installer name, D61 is for year 2020 and G613 is for intended month january but it's not working all throughout the table.
How can I fix this. Thanks.
Did you try more exact ranges, like AX7:AX10000, etc.?