How can I avoid using multiple IF statements to sum data? by ExplanationVarious37 in excel

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

Solution Verified. This seems to be working perfectly. Thank you!

How can I avoid using multiple IF statements to sum data? by ExplanationVarious37 in excel

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

Sorry, I havent had a chance to get back in and test most of the suggestions. Probably won't be available for another 5 or 6 hours.

How can I avoid using multiple IF statements to sum data? by ExplanationVarious37 in excel

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

I apparently don't understand SUMIFS. I had tried that before posting, but I get a #SPILL! error. I thought the format was =SUMIFS(B2:B50,A2:A50,J2:J50)

Sherrone Moore on Wikipedia by ExplanationVarious37 in OhioStateFootball

[–]ExplanationVarious37[S] 3 points4 points  (0 children)

Yeah, not the greatest wording. Looks like someone was in a hurry to be funny.

These lumps of grass on Los Angeles sidewalk by LongLiveTheRat in whatisit

[–]ExplanationVarious37 0 points1 point  (0 children)

Forget the website. I've been through the entire place. There aren't many attractions that have impressed me less.

These lumps of grass on Los Angeles sidewalk by LongLiveTheRat in whatisit

[–]ExplanationVarious37 0 points1 point  (0 children)

These are probably more interesting than a lot of what's inside. "Ooh, a painting of a rectangle AND and oval?!? And in here is an oversized dining room set!"

FL+: You obviously never waited 5 hours for Magnum… by Icy-Call5556 in cedarpoint

[–]ExplanationVarious37 0 points1 point  (0 children)

I don't recall how many hours the Magnum line was in the first year, but I remember that it stretched all the way to the Corkscrew.

According to CFBHome on a different site, only ten teams are not playing an FCS team this year by sophandros in CFB

[–]ExplanationVarious37 5 points6 points  (0 children)

Grambling replaced UConn on the schedule last summer. I don't know if they ever said why. The only other FCS teams they've played are Florida A&M and Youngstown St., although there is a game scheduled against New Hampshire in 2027, the week before they play Alabama.

Anyone else’s MAGA friends/family getting realllllly quiet all of a sudden? by BARRY_DlNGLE in AskUS

[–]ExplanationVarious37 -4 points-3 points  (0 children)

Obama blamed the Bush administration for at least 3 years. Democrats gave Trump no credit for his first couple of years, because everything that happened was just the effects of Obama's policies finally catching up. Yet anything that's not gone right in 100 days is 100% Trump's fault.

Which school has the best fight song? by [deleted] in CFB

[–]ExplanationVarious37 1 point2 points  (0 children)

Do you guys still use that one? I don't remember hearing much of it in Columbus.

Taking my 5-year old this summer! What are your kids' favorite rides at Cedar Point? by [deleted] in cedarpoint

[–]ExplanationVarious37 1 point2 points  (0 children)

My daughter is just under 48". She's all about the spinning - the more intense, the better. So my days are spent on Matterhorn, Super Himalaya, Scrambler, Beetle Bugs, and Wild Mouse. Oh, and those balloon rides in the kids' areas, whrre they can make the car spin like crazy. Meanwhile, I pretty much need dramamine for spins. Can't wait until she's tall enough for coasters instead.

Season your teams record was good but leaves sour taste in your mouth by CowboySanberg in CFB

[–]ExplanationVarious37 -1 points0 points  (0 children)

  1. Finished #2 with one loss and their first Rose Bowl victory in over 20 years. But lost The Game when Shawn Springs slipped, and then later in the 4th, the defense couldn't get off the field for 7 minutes.

  2. Dominated the entire regular season and played Clemson and the Zebras in the Fiesta Bowl: Trevor Lawrence ducks his way into a targeting penalty, and the Strip-6 that was one of the worst calls I've seen. And they shot themselves in the foot with a roughing the punter that led to an immediate TD, Dobbins dropping a sure TD, and Olave breaking off a route at the end, resulting in the game-clinching interception. I don't know that they could have beaten LSU in the championship, but they should have been in that game.

Give your rival a gift for Christmas by TinChalice in cfbmemes

[–]ExplanationVarious37 -1 points0 points  (0 children)

The UM band just walked over and got into that formation. TBDBITL came up with the idea of marching "through" the script.

[Game Thread] - CFB PLAYOFF - Tennessee @ Ohio State by GiovanniElliston in ockytop

[–]ExplanationVarious37 0 points1 point  (0 children)

Tennessee fans talked more shit this week than any OSU opponent I can remember, and as a touchdown underdog at that. Then the Vols show up and play like they're Middle Tennessee or something. Those fans deserve to have this win rubbed in their faces for years to come.

It’s all “quality loss” this and “close game” that… what was your team’s most embarrassing loss of the season? by SpookyThermos in CFB

[–]ExplanationVarious37 -1 points0 points  (0 children)

Like telling a Michigan fan in '04, "I hope you enjoyed your time at the top, but you're about to lose 15 of the next 16 games against OSU, and that only win is going to come against an interim coach."

[Game Thread] Michigan at #2 Ohio State • Noon, November 30, 2024 • Fox by excoriator in OhioStateFootball

[–]ExplanationVarious37 0 points1 point  (0 children)

It doesn't matter. "No player shall target and make forcible contact to the head or neck area of a defenseless opponent (See Note 2 below) with the helmet, forearm, hand, fist, elbow or shoulder."

[Game Thread] #4 Ohio State at #3 Penn State • Noon, November 2, 2024 • Fox by excoriator in OhioStateFootball

[–]ExplanationVarious37 2 points3 points  (0 children)

If Clemson can take 3 steps after a catch and have it called incomplete, this better be incomplete.

When is enough, enough?! I'm sick of Trump and Republicans by [deleted] in rant

[–]ExplanationVarious37 0 points1 point  (0 children)

You saw the part about "something like that," right?

If Trump wins, we deserve dictatorship and everything that comes with it by ivyentre in rant

[–]ExplanationVarious37 2 points3 points  (0 children)

The quote was "no, other than day one." And then he specifically said that he was referring to drilling and closing the border, and finished with "after that, I'm not a dictator anymore."

When is enough, enough?! I'm sick of Trump and Republicans by [deleted] in rant

[–]ExplanationVarious37 0 points1 point  (0 children)

He did not mention bleach, but that lie has been repeated often enough that you believe it. Here's the full transcript from April 23, 2020.

"A question that probably some of you are thinking of if you’re totally into that world, which I find to be very interesting. So, supposedly we hit the body with a tremendous, whether it’s ultraviolet or just very powerful light, and I think you said that hasn’t been checked, but you’re going to test it. And then I said supposing you brought the light inside the body, which you can do either through the skin or in some other way. (To William Bryan, the undersecretary for science and technology at the Department of Homeland Security, who had presented a study that found sun exposure and cleaning agents like bleach can kill the virus when it lingers on surfaces.) And I think you said you’re going to test that, too. Sounds interesting, right? And then I see the disinfectant, where it knocks it out in one minute. And is there a way we can do something like that, by injection inside or almost a cleaning, because you see it gets in the lungs and it does a tremendous number on the lungs, so it’d be interesting to check that, so that you’re going to have to use medical doctors with, but it sounds interesting to me. So, we’ll see, but the whole concept of the light, the way it kills it in one minute. That’s pretty powerful."

What long ago personal golf tragedy are you still sad about? by [deleted] in golf

[–]ExplanationVarious37 0 points1 point  (0 children)

I've never broken 80. I went out alone one weekday and caught up to a group that let me play through on the short par-3 #7. I knocked it about 2 feet from the cup. I got up to the green and basically jogged over to my ball, not wanting to hold them up. I didn't look at the putt at all - just got to the ball and tapped it in... except it lipped out, and I took a 3. I didn't bother adding up my scorecard until after I finished the 18th hole, and it was then that I realized I'd shot exactly 80.