I am trying to use the countif or countifs function to count the number of genres...

I am trying to use the countif or countifs function to count the number of genres used to describe a film and no matter what syntax I use, the result is 0. Can I use the countif(s) function to count columns? I want to count the number of movies that have 3 or more genre's associated with them.

Here is a sample of the data I am working with:

primarykey	Movie	Genre1	Genre2	Genre3	Genre4	Genre5	Genre6	Genre7
tt0499549	Avatar	Action	Adventure	Fantasy	Sci-Fi
tt0449088	Pirates of the Caribbean: At World's End	Action	Adventure	Fantasy
tt2379713	Spectre	Action	Adventure	Thriller
tt1345836	The Dark Knight Rises	Action	Thriller
tt5289954	Star Wars: Episode VII - The Force Awakens	Documentary
tt0401729	John Carter	Action	Adventure	Sci-Fi
tt0413300	Spider-Man 3	Action	Adventure	Romance
tt0398286	Tangled	Adventure	Animation	Comedy	Family	Fantasy	Musical	Romance
tt2395427	Avengers: Age of Ultron	Action	Adventure	Sci-Fi

Solutions

Expert Solution

Notice the formula that I have used in cell J2. You have to use that formula in all the cells of the column J.
For example, in cell J3, the formula will be =7-COUNTIF(C3:I3,""), in cell J4, the formula will be =7-COUNTIF(C4:I4,"") and so on.

After getting the no. of genres associated with the films in the J column, I guess you will be able to identify those movies which have 3 or more genres associated with them.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Palindrome Javascript I am trying to write this javascript function to check if a number is...

Palindrome Javascript I am trying to write this javascript function to check if a number is Palindrome.. Palindrome means - a word, phrase, or sequence that reads the same backward as forward, e.g., madam or nurses run. This is the code i have, but it doesnt work. Code: let convertButton = document.getElementsByClassName("btn")[0]; let userInput = document.getElementById("number").value; let results = document.getElementById("result").value; convertButton.addEventListener("click", function (event) { event.preventDefault(); console.log(userInput); if (validatePalidrome(userInput)) document.getElementById("result").innerHTML = "true"; else document.getElementById("result").innerHTML = "false"; }); function validatePalidrome(numbers) { let...

I am trying to implement a search function for a binary search tree. I am trying...

I am trying to implement a search function for a binary search tree. I am trying to get the output to print each element preceding the the target of the search. For example, in the code when I search for 19, the output should be "5-8-9-18-20-19" Please only modify the search function and also please walk me through what I did wrong. I am trying to figure this out. Here is my code: #include<iostream> using namespace std; class node {...

I am trying to create a function in JAVA that takes in an ArrayList and sorts...

I am trying to create a function in JAVA that takes in an ArrayList and sorts the values by their distance in miles in increasing order. So the closest (or lowest) value would be first. It does not need to output the values in anyway, but it should return them so they can be output elsewhere. Please try to use the stub class below. The code for the main class is not necessary. I am only really asking for the...

I am trying to plot a difficult function in MATLAB, however I need to understand the...

I am trying to plot a difficult function in MATLAB, however I need to understand the basics first. I am trying to plot n=0 for x=0:0.01:2pi n=n+1 y(n)=sin(x) end I beleive what this says, is that I want to plot sin(x) over a full period hence from o to 2pi, and I beleive the 0.01 is the incremenation along the x-axis. I am not sure what my n is doing Could smeone please graph this for me with the MATLAB...

I am working on a project. It involves using excel to organize 8 Movies by Genres,...

I am working on a project. It involves using excel to organize 8 Movies by Genres, Revenue, and IMDB scores. I am having a hard time organizing by "genre". I keep getting errors when I try to include it. How can I fix this? I want to run some data analysis but cannot without it. Please list all steps on how to insert into excel. I would like to know for future reference. The data I am working with is...

Palindrome Javascript - NUMBERS I am trying to write this javascript function to check if a...

Palindrome Javascript - NUMBERS I am trying to write this javascript function to check if a number is Palindrome.. Palindrome means - a word, phrase, or sequence that reads the same backward as forward, e.g., 12321 This is the code i have, but it doesnt work. PLEASE MAKE SURE IT WORK BEFORE POST ANSWER, I GOT @ CODE THAT DID WORK BEFORE HTML JavaScript Palindrome Exercise rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.4.1/css/bootstrap.min.css" /> Palindrome Enter a positive number: Is this a palindrome? No...

I am trying to solve this problem, but I don't know which test to use: For...

I am trying to solve this problem, but I don't know which test to use: For average risk funds only, test the proportion of funds with Sales Charges is not 50% use α = 0.10. Explain your conclusion. Here is the contingency table with the data: Sales charge Yes No total Risk Low 6 8 14 Avg 42 34 76 High 24 23 47 Total 72 65 137 Context of the problem: Mutual funds are the most common way people...

Hello, I am trying to write a C++ program that will do the following: Use the...

Hello, I am trying to write a C++ program that will do the following: Use the STL stack container in a program that reads a string, an arithmetic expression to be exact, one character at a time, and determines if the string has balanced parenthesis – that is, for each left parenthesis there is exactly one matching right parenthesis later in the string. Use the following strings to test your program. A+ B - C A * B / (C...

Hi I am having the following problem. At the moment I am trying to create a...

Hi I am having the following problem. At the moment I am trying to create a bode plot for the following function. G(s)=(Ks+3)/((s+2)(s+3)) Note: Not K(s+2)! I then want to plot multiple bode plots for various values of K. Eg. 1,2,3, etc. I am having two separate issues. 1. How do I define the TF with a constant K in the location required (a multiple of s in the numerator) 2. How do I create multiple bode plots for values...

I am trying to figure out which test analysis to use for my research questions. I...

I am trying to figure out which test analysis to use for my research questions. I was thinking about think about multivariate because of the number of variable being addressed in the study but there is also the possibility to use univariate to address each question. What are the current levels of police satisfaction in CMPD jurisdictions? What is the public’s perception of crime in CMPD jurisdictions? Does “hot spot” policing reduce crime in CMPD jurisdictions? How does broken windows...

Subjects