ByR4di0n
Good day,
I have a problem with my Excel.
I have a list of grades 1-6 from over 4000 students.
I would now like to create a formula that tells me how many students got a grade lower than 3.
Maybe the answer is easy, but I'm a bit of a clever person, it would be cool if you could help me.
I need a formula because I want to calculate this every month.
Mega thanks in advance
(1 votes)
Loading...This information can be found in the vehicle encyclopedia. Can someone perhaps explain to me why, when the speed is doubled, the air resistance quadruples. Thank you in advance 🙂
I love working with Excel simply because it has so much potential to optimize workflows, save time and minimize errors. However, I am always surprised by how many superiors are surprised by what I can do with Excel. Not highly complex. (No programming) Managers with almost 25/30 years of professional experience and countless interns and…
Hello, I have a small website (a school project) with several input fields and buttons. The page is designed to create a list of cars that you specify yourself. For this, I use an array containing a bunch of "Car" objects, each of which, logically, has different properties. To do this, I create an object…
This question is a bit complicated, sorry. My question is: if you first retrieve a value from an SQL database using Select and then use Update to insert the value plus 1, errors can occur if two people do it at the same time. How can this be prevented? Kind regards, Bohne47
Hello, In math we are currently working on the topic of centric dilations/similar triangles/1st and 2nd ray theorem. We have been given a task that is really beyond my capabilities. The first picture is the task, the second picture is our teacher's notes, and the third picture is what I understood to some extent. Our…
This can be done, for example, with the function =counting if
A2 stands the note
B2 is the formula
=if(A2>3,1)
Below in column C
=Number(B2:B4002)
The column B can then be hidden.
My idea
=Callif(Cell1:CellN;”>=3″)
And to this: =Number(Cell1:CellN)
Both divided by each other gives you the share of bad students.
Hello, that’s almost exactly what I mean. Can I refer to a cell ?
Sure, but it is also about determining a number directly. Of course, this can also be done in columns and there is a yes/no or respectively with a if function. Create 0/1 value and then add up.
Because counting a cell can only get 0 or 1.
In relation to a cell, =If(A1>3;1;0) as a result would be equal to =Celif(A1;”>3″)