How to Automatically Sum Totals for Room Bookings based on Price Criteria

I am organising a conference and use a spreadsheet for the bookings.

I use one column to record the type of accommodation required for each party with D for Double Room, S for single and T for Twin.

What formula would I need to total these automatically so x Double rooms, y single and z twin ?

I have edited your thread title, which told us nothing at all about your issue.

In future please adhere to these guidelines when opening a thread:

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.