Need Help with Countif Index Match formula

[needhelpwithexcel1]

I need your help! It's been awhile since I wrote advanced formulas. I believe I need to do a countif index match array formula?!?!
I am trying to count anything within the range that has "add" or "x" and also style "65617" and "Group A". Please see photo!

 

[steve the fish]

Hi. Photos wont get you much help generally as its impossible for us to paste it into a workbook and work on supplying an answer. That said yours is relatively simple:

=SUMPRODUCT((A1:A10=J1)*(A1:H1=J2)*((A1:H10="Add")+(A1:H10="x")))

where J1 holds your 65617 and J2 your Group A. Obviously change these ranges to suit your example.

 

[Toadstool]

Hi NeedHelpWithExcel,

SUMPRODUCT will do this for you:

NeedHelpWithExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Style	Group A	Group B	Group A	Group C	Group A	Group B	Group C	Group A
2	663344		X			Drop
3	663347	Add			Add				X		Style	663351
4	663351	Add	X		X	X		Add	Add		Group	Group A
5	663356			X	X	X		X			Result	3
6	663362				X				Add
7	663369		Drop
8	663377				Add			Add
9	660380		Drop		Add	Add		Drop	Drop
10	657050
11	653387					Add
12	649391	Add	Add		X	X		X
13	645062	Add
14	640400			Add	Drop			Add	Add
15	635405	Drop
Sheet1

Cell Formulas
Range	Formula
L5	L5	=SUMPRODUCT(--($B$2:$I$9999={"Add"})*($B$1:$I$1=$L$4)*($A$2:$A$9999=$L$3))+SUMPRODUCT(--($B$2:$I$9999={"X"})*($B$1:$I$1=$L$4)*($A$2:$A$9999=$L$3))

 

[steve the fish]

Hi Toadstool. If you check out my solution you can see how you can do an 'or' test with addition.

 

[Toadstool]

Hi Toadstool. If you check out my solution you can see how you can do an 'or' test with addition.

Yes, I understand.

 

[needhelpwithexcel1]

Just want to say Thank you!! It worked =)