View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cheri
 
Posts: n/a
Default Assigning values to letters

We have a spreadsheet that we are to enter either an "A", "B", or "M" to
designate whether some is "Above", or "Meets", or is "Below" a designation.

An "A" equals 5 points
An "M" equals 3 points
and the "B" equals 0 points

I would like a formula that allows me to designate the value for each entry
in the row and adds the values together. So, if there are 4 "A"s and 5 "M"s,
the result will be 35.

Thanks!