Automatic Totals/Coloured Cells
 

Hi all,

This is probably very straight forward, but I hope someone can assist.

I have a spreadsheet with information about students in a school. Their
names and other information are in columns A - D, and their grades are in
column E onwards. The grades are normally something like "3C" or "5A" etc,
sometime just Y(es) or N(o).

Could someone provide me with a quick formula to total up how many students
achieved a particular grade in each column (so for example, how many students
have 3C against their name in column E).

Along with this, I wondered if there was some programming I could do to make
a particular cell change colour when text is typed into it (for example all
cells containing 5A turn red automatically).

Thanks in advance for any help offered.

Hi Ian,

try this for sum

=countif(E:E,"3C",A:A)

formatconditional formatingcell value isis equal to5a
and press formal botton and select the color

and for coloring the cell use conditional formation



"Ian.UK" wrote:

Hi all,

This is probably very straight forward, but I hope someone can assist.

I have a spreadsheet with information about students in a school. Their
names and other information are in columns A - D, and their grades are in
column E onwards. The grades are normally something like "3C" or "5A" etc,
sometime just Y(es) or N(o).

Could someone provide me with a quick formula to total up how many students
achieved a particular grade in each column (so for example, how many students
have 3C against their name in column E).

Along with this, I wondered if there was some programming I could do to make
a particular cell change colour when text is typed into it (for example all
cells containing 5A turn red automatically).

Thanks in advance for any help offered.