Help with CONTAINS Returning Invalid Data Type

Ronald Anderson

I have the below formula to count if the department contains Facility and the dates are between January 1, 2022 and January 31, 2022. I am receiving the invalid data error. I have validated the Loss Date column is set for dates and the Dept column is set to text/number.

=COUNTIFS(CONTAINS({Dept}, "Facility"), {Loss Date}, >=DATE(2022, 1, 1), {Loss Date}, <DATE(2022, 1, 31))

Regards,

Ron

Kaveri Vipat

Hi Ronald Anderson 

I hope you are doing well, 

I have modified the formula, you can try this formula  

=COUNTIFS({Dept}, CONTAINS("Facility", @cell), {Loss Date}, >=DATE(2022, 1, 1), {Loss Date}, <DATE(2022, 1, 31))  

I hope it works for you!

Thank you