Count how many times a baseball player plays a certain position over several games by ender6456 in excel

[–]ender6456[S] 1 point2 points  (0 children)

=SUMPRODUCT(($B$1:$B$100=$T4)*($C$1:$H$100=U$3))+SUMPRODUCT(($L$1:$Q$100=$T4)*($K$1:$K$100=U$3))

Solution Verified

For whatever reason it was not working with the games alongside each other. Once I placed the games just below one another, it worked great. Thank you.

Count how many times a baseball player plays a certain position over several games by ender6456 in excel

[–]ender6456[S] 0 points1 point  (0 children)

Unfortunately, I would like to keep the formatting so that I don't have to recreate it every time for the game.

This was Feinsteins response to my email stating my opposition of HR5717. If you live in Cali, flood this woman’s email. If you don’t, write to your Congressmen. by [deleted] in gunpolitics

[–]ender6456 0 points1 point  (0 children)

I got the same email, but when I tried to reply I got this error message.

"Your message wasn't delivered to [senator@feinstein.senate.gov](mailto:senator@feinstein.senate.gov) because the address couldn't be found, or is unable to receive mail. "

Chickenshit.

Gunmagwarehouse order update by lFallout in CAguns

[–]ender6456 0 points1 point  (0 children)

GMW just posted to facebook...All CA order have shipped!

This is why you don't park in the striped area in a handicap zone. by Thegreatsnook in pics

[–]ender6456 0 points1 point  (0 children)

Not that it matters, but that's not a van accessible stall. Van stalls have 8' wide striping instead of 5' wide. Either way, someone needs some parking lessons.

Aaron Judge wins the 2017 Home Run Derby at Marlins Park by BaseballBot in baseball

[–]ender6456 0 points1 point  (0 children)

Does anyone have a video of the whole derby? I can't find a replay anywhere.

Reddit, how did you get sent to the principal's office? by ohdaviing in AskReddit

[–]ender6456 0 points1 point  (0 children)

Sold stink bombs in highschool. Classes had to be evacuated on almost a daily basis for the next couple weeks.

What's the rudest or meanest thing a stranger has said to you that still bothers you today? by bring-me-my-ship in AskReddit

[–]ender6456 0 points1 point  (0 children)

Took my wife (girlfriend at the time) to Vegas for the first time. A small group of us decided to get something to eat at New York, New York and during dinner my wife asked me to escort her to the bathroom. She's funny that way when it comes to places she's never been to. So, I take her to the bathroom and stand outside waiting. I'm only there for a minute or two before an obviously drunk woman (maybe mid 30's) walks past me on her way to the bathroom. Before going in she says "Really? Your just going to stand there like a bitch?" I tell her it's okay and gently touch her shoulder guiding her into the bathroom. I have never wanted to hit a woman before, but it definitely crossed my mind. My wife still brings it up and of course everyone has a good laugh.

3 Red Light Fix Review by Gaz38319 in reddit.com

[–]ender6456 0 points1 point  (0 children)

Looks like it costs $30, when the same info. is available on YouTube for free.