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:

[TABLE="width: 400"]
<tbody>[TR]
[TD]Account Name[/TD]
[TD]# of 3 over 3 mos[/TD]
[TD]# 3 over 5 mos[/TD]
[/TR]
[TR]
[TD]Happy Account[/TD]
[TD]?[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]


The sheet I would be building this table off of is as follows- columns are months
[TABLE="width: 400"]
<tbody>[TR]
[TD]Account Name[/TD]
[TD]oct[/TD]
[TD]nov[/TD]
[TD]dec[/TD]
[TD]jan[/TD]
[TD]feb[/TD]
[/TR]
[TR]
[TD]OK Account[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Happy Account[/TD]
[TD]06[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]89[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Thrilled Account[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]blah Account[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]


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)