COUNTIF MONTH AND YEAR SAME FORMULA
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
Answers

Very very close! Give this a try...
=COUNTIF({COLUMMXX}; AND(IFERROR(MONTH(@cell); 0) = 1; IFERROR(YEAR(@cell); 0) = 2019))



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

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

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)

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

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

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)

my friend you are the best !! it worked out now.
Sorry for the many questions, I'm new to SS;

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
Categories
Check out the Formula Handbook template!