View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mits mits is offline
external usenet poster
 
Posts: 10
Default Adding letters instead of numbers

hi

ive got a column with grades ranging from A-G. i am trying to find out how
many A-C grades there are. ive used the following formula but its not working.

=COUNTIF(enla,OR("A","B","C"))

where enla is my named range.

any help appreciated.