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:
Formula: copy to clipboard 
=SUMIF(D2:D49,"R",E2:E49)