title: Total data by category - Excel / Google Drive Spreadsheet
body: <p>Ive got a set of data in a Excel / Google Drive spreadsheet, there are 3 columns : item, price, category.</p>
  
  <p>Ive included an example Google Drive Spreadsheet here - <a href="https://docs.google.com/spreadsheets/d/1JkWoQmo0qHfi8Ld5CEOGOFQtn4dXYzc4kSMEOmAxibM/edit#gid=0" rel="nofollow">https://docs.google.com/spreadsheets/d/1JkWoQmo0qHfi8Ld5CEOGOFQtn4dXYzc4kSMEOmAxibM/edit#gid=0</a> (I have now locked this spreadsheet for editing as Gvee's answer works)</p>
  
  <p>What im trying to do is to total the prices for each category, at the moment what im doing is filtering the category column and then finding the total by highlighting the price column see the total in the bottom right, and manually entering it. </p>
  
  <p>Is there an automated way to calculate the totals for each category ?</p>
  
  <p>Id like to do this using functions (rather than macros) so it can run in both Google Drive Spreadsheets as well as Excel. </p>