I want to get the number of occurances of a grade and its total value in seperate columns

[sumesh56]

In a worksheet of marks of students, i have entered grades A,B,C,D,AND E.Grades are entered in cells o3,AB3,AO3,BB3 AND BO3.

In BQ3,I want to get -in the range of O3:BO3

a)how many "A" are there?
It should display for example A=2,

b) how many "B" are there?
It should display for example B=2,

c)how many "C" are there?
It should display for example C=2,

d)how many "D" are there?
It should display for example D=2,

e)how many "E" are there?
It should display for example E=2.

In BR3, I want to get >

If A=10, B=8, C=6, D=4, E=2 then

display the total value for the grade letters.

Pls see the attached file for more clarity. thanks.

[RudiS]

What determines A? Score of 80-100?
B = 70-79.9?
C = 60-99.9?
D = 50-59.9?
E = 40-49.9?
<40 = "Fail"???

Please clarify.
TX

[etaf]

try
="A="&COUNTIF(O3:BO3, "A")&" B="&COUNTIF(O3:BO3, "B")&" C="&COUNTIF(O3:BO3, "C")&" D="&COUNTIF(O3:BO3, "D")&" E="&COUNTIF(O3:BO3, "E")

If A=10, B=8, C=6, D=4, E=2 then

=(COUNTIF(O3:BO3, "A")*10)+(COUNTIF(O3:BO3, "B")*8)+(COUNTIF(O3:BO3, "C")*6)+(COUNTIF(O3:BO3, "D")*4)+(COUNTIF(O3:BO3, "E")*2)

[sumesh56]

try
="A="&COUNTIF(O3:BO3, "A")&" B="&COUNTIF(O3:BO3, "B")&" C="&COUNTIF(O3:BO3, "C")&" D="&COUNTIF(O3:BO3, "D")&" E="&COUNTIF(O3:BO3, "E")

If A=10, B=8, C=6, D=4, E=2 then

=(COUNTIF(O3:BO3, "A")*10)+(COUNTIF(O3:BO3, "B")*8)+(COUNTIF(O3:BO3, "C")*6)+(COUNTIF(O3:BO3, "D")*4)+(COUNTIF(O3:BO3, "E")*2)

etaf thanks a lot for the response

. I wanted to try your formula in a file. after first two rows it gives the wrong result. pls check and direct me. pls see the attachment.

[etaf]

not sure what the issue is

if you copy it down, it works, the formula in your row 8 is still referening to row 3 and so needs to be change to row 8

a copy and past will work

have a look here

[sumesh56]

not sure what the issue is

if you copy it down, it works, the formula in your row 8 is still referening to row 3 and so needs to be change to row 8

a copy and past will work

have a look here

etaf ,thanks for the response.

your formula, when pasted on the first data row and copy down gives correct result

.
but when it is pasted in the middle row it gives the wrong one.kindly see the attachment.

in sheet-1, the formula has been pasted to row A11.(BQ11) the result it shows is that of the first data row A3. In sheet-2 , the formula has been pasted to BQ7 in ROW 7 but it shows that of the first data row A3. that

means that wherever you paste the formula it starts showing the result of the first data row

. can you edit it so that it becomes universal?

[sumesh56]

etaf ,thanks for the response.
.
but when it is pasted in the middle row it gives the wrong one.kindly see the attachment.

in sheet-1, the formula has been pasted to row A11.(BQ11) the result it shows is that of the first data row A3. In sheet-2 , the formula has been pasted to BQ7 in ROW 7 but it shows that of the first data row A3. that . can you edit it so that it becomes universal?

etaf. thanks a lot for the formula. it works perfect. i pasted the formula in a row other than row3. then the reference is row3 whenever i pasted it. I had to paste it as paste special> formulas. i tried that way. and it is working perfect. thanks once again. have a nice day.

[etaf]

your welcome, glad you have it working now
you just need to ensure if you copy that any rows or columns have changed (if you need them to change to execute the formula correctly)
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here