I want to count items within current month without needing to change the month manually

Elizabeth Jones · 09/09/20

oh goodness; thanks so much for the correction. works great!

Paul Newcome · 09/10/20

Stian Johansen · 01/27/21

I can't get the formula to work with reference to another sheet. It works perfect in the same sheet, but #UNPARSEABLE when referencing.

=COUNTIFS({Another sheet}:{Another sheet}; AND(IFERROR(MONTH(@cell); 0) = MONTH(TODAY()); IFERROR(YEAR(@cell); 0) = YEAR(TODAY())))

Paul Newcome · 01/27/21

@Stian Johansen When referencing another sheet, you only enter the range once like so...

=COUNTIFS({Another sheet}; AND(IFERROR(MONTH(@cell); 0) = MONTH(TODAY()); IFERROR(YEAR(@cell); 0) = YEAR(TODAY())))

Stian Johansen · 01/27/21

That was quick and works! Can't think I didn't try that. Thank you :)

Paul Newcome · 01/27/21

@Stian Johansen Happy to help. 👍️

Raul Cabrera · 09/28/21

Excellent it works for me with some other arguments that i need to filter. Thanks Paul

Answers