Multiple Countifs - I think

[ithoughtiknewit]

I have searched, tired, failed. I am trying to count across multiple cells. For example, A is a name and D is a "problem". I want to see how often a person has that problem and countifs worked great. Now the problems are spread across C:H and it won't work. Is there a better function?

In this example, how can I tell how many times Jay has a Weather problem:

Thank you all!!!

Name​	Contract​	Problem 1​	Problem 2​	Problem 3​	Problem 4​	Problem 5​	Problem 6​		Jay	=countifs(A:A,"Jay", C:H, "Weather")
Jay​	13234​	Weather​	Fuel​	People​					Weather​
Mike​	65655​	People​	Weather​						People​
Jay​	245632​	None​							Fuel​
Chris​	13254​	None​
Jay​	34354​	Weather​	People​
Jay​	3343554​	Fuel​	Weather​

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Name	Contract	Problem 1	Problem 2	Problem 3	Problem 4	Problem 5	Problem 6		Jay
2	Jay	13234	Weather	Fuel	People					Weather	3
3	Mike	65655	People	Weather						People	2
4	Jay	245632	None							Fuel	2
5	Chris	13254	None
6	Jay	34354	Weather	People
7	Jay	3343554	Fuel	Weather
8
9
Master

Cell Formulas
Range	Formula
K2:K4	K2	=SUMPRODUCT(($A$2:$A$7=$J$1)*($C$2:$H$7=J2))

 

[ithoughtiknewit]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Name	Contract	Problem 1	Problem 2	Problem 3	Problem 4	Problem 5	Problem 6		Jay
2	Jay	13234	Weather	Fuel	People					Weather	3
3	Mike	65655	People	Weather						People	2
4	Jay	245632	None							Fuel	2
5	Chris	13254	None
6	Jay	34354	Weather	People
7	Jay	3343554	Fuel	Weather
8
9
Master

Cell Formulas
Range	Formula
K2:K4	K2	=SUMPRODUCT(($A$2:$A$7=$J$1)*($C$2:$H$7=J2))

That did it!!!! Thank you!!!!!!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.