CODEWITHSUNDEEP
excelexcel-formulaformulacountif
J. McCormick
J. McCormick

Reputation: 15

Two Texts in a Formula

Probably an incredibly easy change but I seem to have a brain fart in this. I have a column and I want my formula to search for both "Open" and "In-Transit". 

=COUNTIFS('Warner Robins'!A:A,"Open",'Warner Robins'!G:G, "PAB")

Upvotes: 1

Views: 49

Answers (2)

zipa
zipa

Reputation: 27879

Or you can go with this one:

=SUM(COUNTIFS('Warner Robins'!A:A,{"Open","In-Transit"},'Warner Robins'!G:G, "PAB"))

Generally makes it easier for multiple OR clauses.

Upvotes: 0

Gary's Student
Gary's Student

Reputation: 96773

perhaps:

=COUNTIFS('Warner Robins'!A:A,"Open",'Warner Robins'!G:G, "PAB")+COUNTIFS('Warner Robins'!A:A,"In-Transit",'Warner Robins'!G:G, "PAB")

Building an OR into a formula can be tough...........easier to just add up the cases.

Upvotes: 2

Related Questions