COUNTIF MONTH AND YEAR SAME FORMULA

Técnica Engenharia

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

Paul Newcome

Very very close! Give this a try...

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

Técnica Engenharia

Thanks @Paul Newcome

Help Very fast !!

Paul Newcome

Happy to help! 👍️

Técnica Engenharia

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})

Paul Newcome

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

Técnica Engenharia

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)

Paul Newcome

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

Técnica Engenharia

did not work

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

Paul Newcome

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)

Técnica Engenharia

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

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

Paul Newcome

Happy to help! 👍️

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