Simple question, Countif/Sumif

[ampeper]

Good morning all,

I hope it is alright that I start with a basic question.

I am working with the CountIfS(....) and Sumif() formulas.

Do you know if there is a way to count using some type of 'Or' within the formula? For example, I am using countif based on keywords. Is there a way to count for two different key words, =COUNTIFS(Table1!B:B,"*Red*") or.... blue....

I hope I explained this thoroughly enough. I need it to truly sum on more than one keyword, but not an 'and' function.

Thank you all!

[Richard Buttrey]

Yes, you just need to ADD two COUNTIFS()/SUMIFS(). As you rightly identify a single COUNTIF() is esentially and AND condition. So just use

=COUNTIFS(Table1!B:B,"Red")+COUNTIFS(Table1!B:B,"Blue")

Alternatively and assuming the underlying data is in a normalised 2 dimensional table then use a Pivot Table.

[ampeper]

Thank you Richard!

[Tony Valko]

One way...

=SUM(COUNTIF(Table1!B:B,{"Red","Blue"}))

[Richard Buttrey]

One way...

=SUM(COUNTIF(Table1!B:B,{"Red","Blue"}))

...even better