COUNTIF FORMULA HELP

tmagana

Is there a better way to pull only the previous year data?

COUNTIFS({M&A Program Interest}, CONTAINS("Buyer Consult", @cell), {M&A Intake Form Range 1}, @cell > TODAY(-360)

Current formula above

Michael Drayton

Hello @tmagana Just to clarify, are you looking to pull a year from current date or "2022" data? if its the later, I think you can parce your desired date column for the year. =YEAR([DateColumn]@row).

If your looking the phrase "Buyer Consult" in 2022, than your formula can look like:

=IF(AND(Year@row = 2022, [Range 1]@row = "Buyer Consult"), "Match", "No Match")

Let me know if this did the job or got close. LOL!!

I'm not exactly sure the results you want to produce.