Formula for counting with two criteria, name and counting for baseball stats

[elketa1252]

Guys,

I have a baseball team and would like a formula to keep the stats. For example, I would like a formula in Cell F3 that counts how many 1b(from Cell F2) does Salvador Martinez(Cell B3) has in the range B33:F:40. So this formula would need to match B3 and find the rows where Salvador Martinez is and add all the 1b. The return would be 3, the ones in yellow. I would use the formula for the other players and for the different stats found in ranges F:2N2. Just to throw another example, these are in red for Jose Perez HR, Cell I7, this formula would return 2 here. Any help would be much appreciated. I have tried all types of formula, index match sumproduct and just cannot do it. Sorry for my english, it's my second language.

Thank you. And I tried upload a picture but it's asking me for an URL instead of uploading from my computer.


B C D E F G H I J K L M N O P Q R S

2 Name	PA	AB	H	1b	2b	3b	HR	ROE	SACf	BB	GDP	Ks	RBI	RUNS	BA	OB%	Slug%
3 Salvador Martinez	0	0	0	0	0	0	0	0	0	0	0	0	0	0	#N/A	#N/A	#N/A
4 Miguel Rosario	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000	0.000
5 Frank Guzman	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000	0.000
6 Galindo Gomez	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000	0.000
7 Jose Perez	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0.000	0.000	0.000
33 Salvador Martinez 2b 1b 2b hr 34 Yoel Martinez 2b hr 2b 1b 35 Jose Perez 2b 1b hr hr 36 Miguel Rosario hr 2b 3b 3b 37 Frank Guzman 1b 2b 3b 2b 38 Salvador Martinez 3b 2b 3b 3b 39 Galindo Gomez 2b 3b 3b 2b 40 Salvador Martinez 2b 1b 1b hr <tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

Automatic is indeed correct.

 

[elketa1252]

Ok got it everybodyyy. Thanks you. I had mispelled Salvador so that's why it wouldn't match. Oh lord thank you all sorry for everything. So embarassed

 

[kweaver]

The formula in B2 (first example) will return a 0 because there aren't any PAs found. Then, drag the formula in B2 across as well as down and the other sums will be calculated.

 

[kweaver]

Imagine how Salvador will feel!

 

[elketa1252]

The formula in B2 (first example) will return a 0 because there aren't any PAs found. Then, drag the formula in B2 across as well as down and the other sums will be calculated.

Thank you. I had mispelled so it couldn't find the match. So embarrased for wasting all of you your time. Thank you all for the help.

 

[elketa1252]

Imagine how Salvador will feel!

lol

 

[Fluff]

No need to be embarrassed, we've all been there.The main thing is it's working.

Thanks for the feedback