Looking for help with "Contains"
I am looking for some help with the Contains function. I currently have the following formula which is working fine.
=COUNTIFS({2021 Archive Range - RFI Reason}, "Census", {2021 Archive Range Assigned To}, "JP Pedicino")
I need to update it to search for CONTAINS "Census" in the 2021 Archive Range - RFI Reason range
and
Equal to "JP Pedicino" in the 2021 Archive Range Assigned To range.
Best Answer
-
Below is the syntax for how you would use the CONTAINS function.
=COUNTIFS({2021 Archive Range - RFI Reason}, CONTAINS("Census", @cell), {2021 Archive Range Assigned To}, @cell = "JP Pedicino")
Answers
-
Below is the syntax for how you would use the CONTAINS function.
=COUNTIFS({2021 Archive Range - RFI Reason}, CONTAINS("Census", @cell), {2021 Archive Range Assigned To}, @cell = "JP Pedicino")
-
Thank you so much for your assistance Leibel!
Help Article Resources
Categories
Check out the Formula Handbook template!