If you have a column with two values (pass/fail), how do you get it to say how many people passed?
There's also a column with percentage results, a pass being over 50%.
My teacher said something about the IF function?
2007-12-09 05:58:40 · 2 answers · asked by . 3 in Computers & Internet ➔ Other - Computers
she probably meant to say to use the countif function
=COUNTIF(A1:A20,"pass")
assume your pass/fail data is in column a1 to a20.
2007-12-09 06:37:37 · answer #1 · answered by expletive_xom 7 · 0⤊ 0⤋
There are two ways to answer this question. The first is to use COUNTIF. In this method you would use or create a blank column next to the pass/fail column and let's say that col is A. Then in col B you would type (use the equal sign for formulas):
countif( whatever the range is,"pass") and in col C type countif( again use range,"fail")
The other method is to use an IF formula (probably the best choice). Use a blank column after the column that has the test scores. Type: If(A1>50,"pass","fail")
In both cases copy the formula down to the last row of test data.
2007-12-09 16:33:58 · answer #2 · answered by Don R 5 · 0⤊ 0⤋