Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning values to letters
If your letters are in C2:C10, for instance, then =5*countif(c2:c10,"A") +
3*countif(c2:c10,"M") will get you the result. "Cheri" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning values to letters
Hi!
Try one of these: =SUM(COUNTIF(A1:J1,"A")*5,COUNTIF(A1:J1,"M")*3) =SUMPRODUCT(((A1:J1="A")*5)+((A1:J1="M")*3)) =SUM(COUNTIF(A1:J1,{"A","M"})*{5,3}) Biff "Cheri" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning values to letters
Thank you so much!!!! That was perfect!
Cheri "bpeltzer" wrote: If your letters are in C2:C10, for instance, then =5*countif(c2:c10,"A") + 3*countif(c2:c10,"M") will get you the result. "Cheri" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
View of x-axis values | Charts and Charting in Excel |