COUNTIFS+CONTAINS+AND

K Miller

I am trying to write a sheet summary formula to count the number of rows where: Sprint Name contains "Maintenance", Date Resolved is not blank, and Bug or Request equals "Bug"

[Sprint Name]:[Sprint Name], CONTAINS("Maintenance")

and

[Date Resolved]:[Date Resolved], <>""

and

[Bug or Request]:[Bug or Request], "Bug"

I tried the following: =COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance"), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request") but I receive an #INCORRECT ARGUMENT SET error.

Carson Penticuff

CONTAINS() must include the range to compare. You can use @cell in this instance.

=COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance", @cell), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request")

Carson Penticuff

CONTAINS() must include the range to compare. You can use @cell in this instance.

=COUNTIFS([Sprint Name]:[Sprint Name], CONTAINS("Maintenance", @cell), [Date Resolved]:[Date Resolved], <>"", [Bug or Request]:[Bug or Request], "Request")

K Miller

Perfect. Thank you!!