COUNTIF ... AND ... CONTAINS ...

Jessica Griffin

I am trying to count a source sheet if it's and new request and the Business area is HR

I have tried the following

=COUNTIF({Internal Comms Intake Range 2}, "New Request",({Internal Comms Intake Range 3},CONTAINS("HR",@cell))

Came back Unparseable

=COUNTIF({Internal Comms Intake Range 2}, "New Request", AND({Internal Comms Intake Range 3}, "HR"))

Came back Incorrect Argument Set

Brett Wyrick

Hey Jessica - I think you're closer on your second formula.

Instead of COUNTIF and AND, just use COUNTIFS:

=COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake Range 3}, "HR")

Report back and let me know if that works!

Brett Wyrick

Hey Jessica - I think you're closer on your second formula.

Instead of COUNTIF and AND, just use COUNTIFS:

=COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake Range 3}, "HR")

Report back and let me know if that works!

Jessica Griffin

@Brett Wyrick That worked. Thank you!

Brett Wyrick

https://community.smartsheet.com/discussion/comment/310609#Comment_310609

Glad to help! Can you mark the "Answer" above as "Yes" so this shows as closed? Thanks!