elketa1252
New Member
- Joined
- May 19, 2017
- Messages
- 16
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
<tbody>
</tbody>
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 | ||||||||||||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>