Game name drop count

People were accusing me of making too big a deal out of his name-dropping, maybe I was. I'd much rather admit that I was wrong than continue to be wrong, and the prospect that I was just parroting a stereotype instead of actually thinking for myself was gnawing away at me. And then I realized I actually had the very real and very rare chance to find out, completely objectively, mathematically even, if I was exaggerating Game's name drop tendency or not.

All it would take was some planning and a little meth to keep me energized some good ol' fashioned hard work. So I went through the entire first disc of Documentary 2, cataloged every single name drop, and spoiler alert, it turns out that nope, I wasn't exaggerating at all. The Game really is hip-hop's most name-dropping rapper by a staggeringly large margin and I can prove it.

Here's how. As exact as I tried to be, counting name drops on rap songs is an imperfect science, mostly because it's a completely ridiculous science I invented about an hour ago. Maybe I actually should count non-famous names? Maybe I should count his many album title references; after all, isn't mentioning It Was Written essentially the same thing as mentioning Nas?

The line between a name drop and a clever reference in a punchline can be razor thin, did I distinguish between them properly? In other, more closely contested cases those questions may matter more, but as you'll see, in Game's case the results are so clear that questions of nuance just didn't end up statistically mattering much.

Dre, R. Note : I didn't count the Ric Flair reference, that one felt like more of a pure punchline than a name drop. Note : Great example of the line between name drop and clever reference, but since the Luniz are a real, actual group whose members are still alive, I'm counting it. Note : Multiple name drops from Sha Sha, including one of Dr. Dre, of course, but I'm only counting Game's actual lines.

Note : Didn't count the Huxtables name drop, didn't feel right to count a fictional family. Live performance is so important that crafting such a strategy requires input from not just a manager, but also a booking agent. Like Eric Wright said Eazy". Note : Not counting D'jango for the same reason I didn't count the Huxtables, and as mentioned above, I'm not counting the multiple "Ye" references because he's referring to the shoe there, not literally Kanye West.

Note : Didn't count the Bruce Lee reference because Lee's been dead so long it felt like more of a pure punchline reference. Also, didn't count the It Was Written reference as a Nas name drop under the no album titles corollary.

Note : Didn't count the Farakkhan, Buddha, and Jesus mentions because it just didn't feel right to views those as "name drops. Note : The songs hook mentions Eazy-E and Nate Dogg, but since a hook by its nature repeats, I'm only counting those as a singular name drop, although he does mention Eazy again in a verse, so that's two total Eazys on this song.

And yes, I'm taking this very seriously. Sweet baby Jesus that's a lot of name drops. Before I started this experiment I obviously expected the number to be high, but I estimated something like Even 50 names seemed like a reach, but ? Let's take a quick musical break to let the reality of that number sink in.

But in keeping with the scientific spirit of this article, just the stats from Game's album alone aren't enough. We need a control group.

So I ran through the same process for three other recently released albums that had ties to Documentary 2. Here are those results:. Now, I'm not about to run the numbers on every album released this year because while I'm clearly insane, even I'm not that insane. So can I say with absolute, unshakeable uncertainty that Game is hip-hop's most name-dropping rapper?

Under oath, no, I cannot. There could be some other rapper out there who name drops more but come on now. Just look at those numbers. None of those three albums, which together are a fair, wide-ranging sample of modern hip-hop, top more than one name drop per song, and Game's pushing 9.

It's not even close. I could take away every even borderline name drop, cut Documentary 2 's total name drops in half, and it's still more than seven times higher than Kendrick Lamar's, 20 times higher than Drake's. You should simply make one CountIf for each of you ranges and make the sum of the results of all these CountIfs Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 2 months ago. Active 8 years, 2 months ago. Viewed 4k times. Blease Blease 1, 3 3 gold badges 37 37 silver badges 60 60 bronze badges. Define DropLists as one, contiguous range. Gary'sStudent I have other items between them in the same column — Blease. That's O. Gary'sStudent is there no other way, incase they include "Yes"? I would like to use this method to total up the lists and construct some other formula too.

COUNTIF only accepts a single range as first argument - you can't circumvent that by using a named range to join discrete ranges — barry houdini. Add a comment. Active Oldest Votes. DataSmarter DataSmarter 2 2 silver badges 14 14 bronze badges.

Mark Fitzgerald Mark Fitzgerald 2, 3 3 gold badges 22 22 silver badges 29 29 bronze badges.