Help count grade

[Logan]

Hi,
I inherited a excel file, which contain a student's
information in the class including grade.

Example:

Student name Grade
Column A Column B

I want to be able to have Excel count how many "F' is in
the class. If possible I would like to have highlight
the "F" grade only if possible.

Thanks,
Logan

 

[Sai S. Vy]

-----Original Message-----
Hi,
I inherited a excel file, which contain a student's
information in the class including grade.

Example:

Student name Grade
Column A Column B

I want to be able to have Excel count how many "F' is in
the class. If possible I would like to have highlight
the "F" grade only if possible.

Thanks,
Logan

Hi,
To determine how many students in the class got
an "F" grade, do this:

Count grade:
1. Click on the cell where you want the anwser to display
2. Click on the "Fx" bottom located at the top-left hand
side
3. A "Insert Function" window will appear, under "Select
a Function" scroll down and select the "countif" option
and hit o.k
4. A "Function Arguments" window will appear,
"On Range" select the cell column or row with the
grade by highlighting the whole grade area.
Next click on the "Criteria" text box and type
in "F" or any grade you wish to count and click o.k

To highlight a cell do this:
1. Highlight the grade area
2. Go to Format, scroll down and select "conditional
formatting".
3. A "Conditional Formatting" window will appear.
Under "Condition 1" choose "equal to" in the middle
text box and type in "F" in the text box on the right.
4. Click on the "Format" button under where you type
in "F" and click on the "Pattern" tab, and look for a
drop down "Pattern" box and choose the texture style you
like and then choose the color and click o.k and o.k
again to view the result.

Sai S. Vy

 

[Don Guillett]

try
=countif(b:b,"F")

 

[Dean]

Hi, first select the column that has the grades. Second,
select the format tab and click on conditional
Formatting... Third, the Conditional Formatting dialog
box will appear. For Condition 1, in the first window,
select "Cell Value Is". Second window, select equal to.
Third window, type F or ="F". Fourth, select the
Format... button. Now the Format Cells dialog box will
appear. Select the Patterns tab. Then under Color: pick
the color you want the F to be highlighted and then click
on OK. Last, click OK on the Conditional Formatting
dialog box. Hope this helps.