• Please use cell references to the data page (when I do this it gives me ) but I know thats not the right answer)
• • Write a formula in the #movies column and TRUE row to determine the number of memorable (TRUE) movies. Copy the formula down to determine the number of non-memorable (FALSE) movies.
  • Write a formula in the Total Financial Value column and TRUE row to determine the total financial value of all memorable movies. Copy the formula down to determine the total financial value of all non-memorable movies.

the long list is where the data is coming from for "summary"

A B C D E F G Rank 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Rating Title 12 8.8 12 Angry Men 75 8.3 2001: A Space Odyssey 157 8.1 8 1/2 230 7.9 A Christmas Story 46 8.4 A Clockwork Orange 223 8 A Streetcar Named Desire 238 7.9 Ace in the Hole 47 8.4 Alien 63 8.4 Aliens 81 8.3 All About Eve 214 8 All Quiet on the Western Front 80 8.3 Amadeus 36 8.5 American Beauty 209 8 American Gangster 39 8.5 American History X 144 8.1 Amores perros 220 8 Anatomy of a Murder 130 8.1 Annie Hall 34 8.5 Apocalypse Now 2401 7.9 Arsenic and Old Lace 105 8.2 Back to the Future 244 7.9 Barry Lyndon 102 8.2 Batman Begins 158 8.1 Battaglia di Algeri, La 198 8 Belle et la bte, La 133 8.1 Ben-Hur 213 8 Big Fish 97 8.3 Blade Runner 237 7.9 Blood Diamond 204 8 Bonnie and Clyde 65 8.4 Boot, Das 98 8.3 Braveheart Votes Year Most Memorable Financial Value 68,806 1957) TRUE $ 137,612 117,475 1968 FALSE $ 234,950 18,909 1963 FALSE $ 37,818 41,134 1983 TRUE $ 82,268 136,113 1971 TRUE $ 272,226 22,533 1951 FALSE $ 45,066 3,782 1951 FALSE $ 7,564 126,642 1979 TRUE $ 253,284 121,959 1986 TRUE $ 243,918 25,199 1950 FALSE $ 50,398 14,787 1930 FALSE $ 29,574 69,831 1984 TRUE $ 139,662 213,186 1999 TRUE $ 2,131,860 69,818 2007 TRUE $ 698,180 148,386 1998 TRUE $ 1,483,860 40,935 2000 TRUE $ 409,350 10,073 1959 FALSE $ 20,146 45,279 1977 TRUE $ 90,558 126,379 1979 TRUE $ 252,758 21,323 1944 FALSE $ 42,646 139,148 1985 TRUE $ 278,296 26,907 1975 TRUE $ 53,814 168,567 2005 TRUE $ 1,685,670 8,500 1966 FALSE $ 17,000 6,604 1946 FALSE $ 13,208 41,485 1959 FALSE $ 82,970 91,756 2003 TRUE $ 917,560 136,758 1982 TRUE $ 273,516 70,970 2006 TRUE $ 709,700 27,648 1967 FALSE $ 55,296 52,789 1981 TRUE $ 105,578 176,215 1995 TRUE $ 1,762,150 25 26 27 28 29 30 31 32 33 A B C 3 1 Summary 2 Memorable: #movies Total Financial Value 3 TRUE 4 FALSE 5 6 7