Returning Calculations based on a search function?

[jencha]

Hello All, thanks in advance for your help! This may be an easier task than I'm making it out to be , but here's my predicament....

I have sheet1 where I am interested in making calculations over several months for instance:

Account Name	# of 3 over 3 mos	# 3 over 5 mos
Happy Account	?	?

<tbody>
</tbody>

The sheet I would be building this table off of is as follows- columns are months

Account Name	oct	nov	dec	jan	feb
OK Account	3	3	3	8	6
Happy Account	06	5	8	89	5
Thrilled Account	3	8	6	3	8
blah Account	3	3	5	2	3

<tbody>
</tbody>

How do I fill in the counts?

 

[Special-K99]

Am I reading this correct?

There are NO occurrences of the number 3 for any of the Happy Account months.

Therefore, what's your expected output based on your example data?

 

[jencha]

Exactly, so I would want to pull 0 in on Sheet1

 

[Fluff]

Maybe

Excel 2013/2016
	Q	R	S	T	U	V	W	X	Y	Z
2	Account Name	oct	nov	dec	jan	feb		Account Name	# of 3 over 3 mos	# 3 over 5 mos
3	OK Account	3	3	3	8	6		Happy Account	0	0
4	Happy Account	6	5	8	89	5
5	Thrilled Account	3	8	6	3	8
6	blah Account	3	3	5	2	3
Archive

Cell Formulas
Range	Formula
Y3	=COUNTIF(INDEX(R3:T6,MATCH(X3,Q3:Q6,0),0),3)
Z3	=COUNTIF(INDEX(R3:V6,MATCH(X3,Q3:Q6,0),0),3)