software

We have a spreadsheet that we are to enter either an quot;Aquot;, quot;Bquot;, or quot;Mquot; to
designate whether some is quot;Abovequot;, or quot;Meetsquot;, or is quot;Belowquot; a designation.

An quot;Aquot; equals 5 points
An quot;Mquot; equals 3 points
and the quot;Bquot; 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 quot;Aquot;s and 5 quot;Mquot;s,
the result will be 35.

Thanks!

If your letters are in C2:C10, for instance, then =5*countif(c2:c10,quot;Aquot;)
3*countif(c2:c10,quot;Mquot;) will get you the result.

quot;Cheriquot; wrote:

gt; We have a spreadsheet that we are to enter either an quot;Aquot;, quot;Bquot;, or quot;Mquot; to
gt; designate whether some is quot;Abovequot;, or quot;Meetsquot;, or is quot;Belowquot; a designation.
gt;
gt; An quot;Aquot; equals 5 points
gt; An quot;Mquot; equals 3 points
gt; and the quot;Bquot; equals 0 points
gt;
gt; I would like a formula that allows me to designate the value for each entry
gt; in the row and adds the values together. So, if there are 4 quot;Aquot;s and 5 quot;Mquot;s,
gt; the result will be 35.
gt;
gt; Thanks!

Hi!

Try one of these:

=SUM(COUNTIF(A1:J1,quot;Aquot;)*5,COUNTIF(A1:J1,quot;Mquot;)*3)

=SUMPRODUCT(((A1:J1=quot;Aquot;)*5) ((A1:J1=quot;Mquot;)*3))

=SUM(COUNTIF(A1:J1,{quot;Aquot;,quot;Mquot;})*{5,3})

Biff

quot;Cheriquot; gt; wrote in message
...
gt; We have a spreadsheet that we are to enter either an quot;Aquot;, quot;Bquot;, or quot;Mquot; to
gt; designate whether some is quot;Abovequot;, or quot;Meetsquot;, or is quot;Belowquot; a
gt; designation.
gt;
gt; An quot;Aquot; equals 5 points
gt; An quot;Mquot; equals 3 points
gt; and the quot;Bquot; equals 0 points
gt;
gt; I would like a formula that allows me to designate the value for each
gt; entry
gt; in the row and adds the values together. So, if there are 4 quot;Aquot;s and 5
gt; quot;Mquot;s,
gt; the result will be 35.
gt;
gt; Thanks!
Thank you so much!!!! That was perfect!

Cheri

quot;bpeltzerquot; wrote:

gt; If your letters are in C2:C10, for instance, then =5*countif(c2:c10,quot;Aquot;)
gt; 3*countif(c2:c10,quot;Mquot;) will get you the result.
gt;
gt; quot;Cheriquot; wrote:
gt;
gt; gt; We have a spreadsheet that we are to enter either an quot;Aquot;, quot;Bquot;, or quot;Mquot; to
gt; gt; designate whether some is quot;Abovequot;, or quot;Meetsquot;, or is quot;Belowquot; a designation.
gt; gt;
gt; gt; An quot;Aquot; equals 5 points
gt; gt; An quot;Mquot; equals 3 points
gt; gt; and the quot;Bquot; equals 0 points
gt; gt;
gt; gt; I would like a formula that allows me to designate the value for each entry
gt; gt; in the row and adds the values together. So, if there are 4 quot;Aquot;s and 5 quot;Mquot;s,
gt; gt; the result will be 35.
gt; gt;
gt; gt; Thanks!