# COUNTIF MONTH AND YEAR SAME FORMULA

Options

I just want to make a filter in the formula for month and year, but I'm not getting it, so I just want to filter what is January (1) and the year 2019 for example. the formula below is not working can you help me?

=COUNTIF({COLUMMXX}; IFERROR(MONTH(@cell); 0) = 1) ; IFERROR(YEAR(@cell); 0) = 2019))

thanks

• ✭✭✭✭✭✭
Options

Very very close! Give this a try...

=COUNTIF({COLUMMXX}; AND(IFERROR(MONTH(@cell); 0) = 1; IFERROR(YEAR(@cell); 0) = 2019))

• Options

Thanks @Paul Newcome

Help Very fast !!

• ✭✭✭✭✭✭
Options

Happy to help! 👍️

• Options

my friend

If I want to add filter of the year in this formula how can I do it?

=SUMIF({Interval 1}; MONTH(@cell) = 1; {Interval 2})

• ✭✭✭✭✭✭
Options

You would take that same AND statement from above and drop it into the criteria section.

• Options

Thanks @Paul Newcome

I have a CRM customer control of our opportunities, it turns out that all new variables were just aimed at evaluating an entire spreadsheet, with the arrival of 2020, our reports need to be separated by 2019, 2020, so my questions.

I can do a search for a text variable in a spreadsheet that only validates the year 2019 or 2020. My current farm does not do this it is only the text validity.

today is just doing text evaluation without year validation

=COUNTIF({Interval 1}; [Coluna2]24)

• ✭✭✭✭✭✭
Options

Yes. The AND function is a good way to combine month and year criteria if you are looking across the same range for both.

• Options

did not work

=COUNTIF({colun_date}; (IFERROR(YEAR(@cell); 0) = 2019); ({Validation_colun_text}; [Validation_cel_text)

• ✭✭✭✭✭✭
Options

You have too may parenthesis and your final criteria is incomplete. You will also need to switch to COUNTIFS (with the S) if you are going to have more than 1 criteria range.

=COUNTIFS({colun_date}; IFERROR(YEAR(@cell); 0) = 2019; {Validation_colun_text}; [Validation_cel_text)

• Options

my friend you are the best !! it worked out now.

Sorry for the many questions, I'm new to SS;

• ✭✭✭✭✭✭
Options

Happy to help! 👍️

Welcome to Smartsheet! And no worries about all the questions. The main purpose of this Community is knowledge sharing.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!