COUNTIF formula

System

This discussion was created from comments split from: COUNTIF between date range and 2 criteria.

dawn.peterson

@Paul Newcome help! Similar issues and I have tried the above and I know I am doing something wrong. Here is my original formula that works from 2024, 1, 1 to date but now I need to update this formula to give me only those items that were created within 2024 and not year to date. Help?

=COUNTIFS({Created}, >=DATE(2024, 1, 1), {Physician Process SOAR 1.0 Range 1}, [Visit Type 2024]@row, {Physician Process SOAR CFT NAME}, CONTAINS("Boomer, Mark", @cell))

Paul Newcome

Try changing the criteria for the date range to specifically call out the year.

=COUNTIFS({Created}, IFERROR(YEAR(@cell), 0) = 2024, ……………………………..)