Thread: COUNTIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PatrickP PatrickP is offline
external usenet poster
 
Posts: 10
Default COUNTIF

I am putting together a spreadsheet where I need Excel to count both when a
class is scheduled and when a grade is entered. When the class is scheduled
the cell will contain a number designanting the term like 101. Later when
the student recieves a grade the cell would contain the number and the letter
grade, like 101A. How do I get Excel to count the cell under either
condition. I would like it to count if there is either a number only or a
number and a letter but NOT just a letter. Thank you!