Does SUMIF work OK?

[alanhig99]

@mariosv

=SUMIFS(B:B; B:B; “>=” & DATE(2022;1;1); B:B; “<=” &EOMONTH(DATE(2022;1;1);0))

I just had to change it to
=SUMIFS(AY:AY,B:B, “>=” & DATE(2022,2,1),B:B, “<=” &EOMONTH(DATE(2022,2,1),0)) to sum up col AY, and yes indeed that works. Many thanks. -I didn’t know there was an EOMONTH function. So useful.