Query for specific characters in a spreadsheet

  • Thread starter Thread starter Vicki B
  • Start date Start date
V

Vicki B

I used Excel to track student attendance for a class this summer and used one
character to indicate attendance, another absence, a third for cancellation,
etc... Is there a way to query how many of each of these characters appear
in the spreadsheet?
 
=COUNTIF(range,"A")

Where range would be a column or row that would contain the character.A for
absence.

You will need a formula for each character.


Gord Dibben MS Excel MVP
 
Back
Top