excel 2010 question

[andy.pratt_73]

Hello,

Have a column with three values of R,U,C. Will call this column D..
Range of this column is from d2:d49..
The column next to it is column E with the same ranges.
The value of column E are different in each row but the formula I have for column E is this..=F7+G7+H7+I7..
This extends down from 2 through 49.
What I am trying to do is combine the results from column E with the values of column D. To get a total of each value from the number in column E . see below..
D E

R 1
C 3
R 1
U 2
R 1
R 2

sooo.. with the occurrence of all values of R in column D equaling to 5 and same thing with all values of C and U.. to show an answer in a specific cell

[Aardigspook]

Welcome to the forum.

Unfortunately, your post title does not comply with Rule 1 of the Forum Rules http://www.excelforum.com/forum-rule...rum-rules.html
(1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search.)
Please change the title of your thread by clicking EDIT on the original post, then the Go Advanced button, then change the title. Thank you.

To get a total of the numbers against 'R', use this in the cell where you want the count:

Please Login or Register  to view this content.

[andy.pratt_73]

Thank you. For your quick response and will abide by the rules next post.