People ask me about the funniest movies list and wonder how things get included. To summarize, in 2017 I searched the internet for lists of “Funniest Movies of All Time” and I specifically looked for lists that were made by groups, organizations, or voting, rather than on any one person’s opinions. Here are the sources I ended up using:

I brought all their lists into Excel and assigned them numerical values based on their rank in each list. The first tab in the spreadsheet is the Raw Data. This is just the lists directly imported as I found them. The Tabulation tab is where I combined all the lists into one huge list, including the ranking each one received.

The rankings only mean so much, though, if the movie is only in one or two of the lists. Movies that show up on most of the lists are obviously more deserving of a higher rank than ones that are only on a couple. So I took each movie’s average ranking score and weighted it based on a count of how many lists the movie was in. That’s the last tab in the spreadsheet, and that’s the source of my final list. See below for the top 50 to give you an idea. You can use the spreadsheet for the complete list of 343 movies that were on at least one of those 17 lists I used.

1Airplane! (1980)5.751636
2Monty Python and the Holy Grail (1975)8.151363
3Blazing Saddles (1974)13.071493
4Annie Hall (1977)11.2010112
5The Big Lebowski (1998)13.5012113
6Anchorman: The Legend of Ron Burgundy (2004)16.8614120
7Life of Brian (1979)13.8211126
8Dr. Strangelove (1964)18.6213143
9This Is Spinal Tap (1984)22.6715151
10Borat (2006)18.3611167
11Caddyshack (1980)19.1811174
12Some Like It Hot (1959)17.6010176
13Animal House (1978)21.3312178
14Duck Soup (1933)16.449183
15The Naked Gun (1988)20.1811183
16Groundhog Day (1993)20.2711184
17Dumb & Dumber (1994)17.679196
18Ghostbusters (1984)28.0714201
19Young Frankenstein (1974)30.7114219
20The Hangover (2009)18.258228
21The 40-Year-Old Virgin (2005)25.449283
22The Jerk (1979)34.9212291
23Superbad (2007)25.388317
24Shaun of the Dead (2004)29.009322
25There’s Something About Mary (1998)36.9111336
26Withnail & I (1987)17.205344
27South Park: Bigger, Longer & Uncut (1999)41.4212345
28Office Space (1999)35.2010352
29The Producers (1968)24.867355
30The General (1926)21.336356
31Planes, Trains and Automobiles (1987)32.569362
32The Blues Brothers (1980)36.9010369
33Step Brothers (2008)26.437378
34Raising Arizona (1987)30.638383
35Ferris Bueller’s Day Off (1986)27.437392
36Happy Gilmore (1996)23.676394
37Austin Powers: International Man of Mystery (1997)28.007400
38Bringing up Baby (1938)21.605432
39Old School (2003)34.638433
40Bridesmaids (2011)27.176453
41A Fish Called Wanda (1988)36.758459
42MASH (1970)33.007471
43National Lampoon’s Vacation (1983)28.676478
44Modern Times (1936)19.754494
45Ace Ventura: Pet Detective (1994)34.577494
46American Pie (1999)34.577494
47Napoleon Dynamite (2004)34.867498
48Wayne’s World (1992)31.676528
49City Lights (1931)21.254531
50A Night at the Opera (1935)22.754569