I need to insert an OR function in the middle of a countif..

[dericm]

Here is the function:
=COUNTIFS(Container!$E2:$E907,"CP15BHS1",Container!$H2:$H907,"_Inventory",Container!$P2:$P907,"C")

Currently, I am trying to get this to also count an additional text string here:

=COUNTIFS(Container!$E2:$E907,"CP15BHS1",Container!$H2:$H907,"_Inventory",Container!$P2:$P907,"C")

I would like it to count _Inventory and _RTI in the selected range..

I'm not very savvy in excel, but I would imagine there's a way to use an OR function within a countifs(), but I havent been able to find anything online yet..

Any help would be appreciated! )

 

[dericm]

=COUNTIFS(Container!$E2:$E907,"CP15BHS1",Container!$H2:$H907,"_Inventory",Container!$P2:$P907,"C")+COUNTIFS(Container!$E2:$E907,"CP15BHS1",Container!$H2:$H907,"_RTI",Container!$P2:$P907,"C")

This has thus far been my solution, but I know there's a more condensed function

 

[sheetspread]

You don't have to add them, try something like:

Excel 2010
	A
1	Name
2	_Inventory
3	_RTI
4	X
5	_RTI
6	_Inventory
7	_RTI
8	Y
9	_RTI
10	Y
11	Y
12	_Inventory
13	X
14	_Inventory
15	Z
16	_Inventory
17	Y
18	_Inventory
19	_RTI
20	_RTI
21
22	12
Sheet5

Cell Formulas
Range	Formula
A22	=SUM(COUNTIFS($A$2:$A$20,{"_Inventory","_RTI"}))