Is December somehow special in Google Sheets?

user_359862 0
Viewed 32

I count the number of transactions made per month

=if(COUNTIF(ArrayFormula(month(
        indirect($H$12&"!$F$3:F")
        )),10)
=0,"",COUNTIF(ArrayFormula(month(
        indirect($H$12&"!$F$3:F")
        )),10)
)

Where 10 is October, while referencing a sheet named in $H$12. This works well for months 1-11.

When it comes to December, I am getting a seemingly random (wrong) integer back.

Is December somehow special?

google-sheets
1 Answers

I ended up using Filter. Seems to work perfectly fine

=COUNTA(filter(indirect($H$12&"!$A$3:A"),month(indirect($H$12&"!$F$3:F"))=10))

user_3598620
Related