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

Jessica Griffin · 11/10/21

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 · 11/10/21

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 · 11/10/21

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 · 11/10/21

@Brett Wyrick That worked. Thank you!

Brett Wyrick · 11/11/21

@Brett Wyrick That worked. Thank you!

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

Formulas and Functions