title: in excel check a column with text value if true return numeric value in next column
body: <p>I have two columns, A, B and C, </p>
  
  <p>Column A has two text values "Petrol" &amp; "Butane" 
  column B has just numeric values (i.e their cost in USD)</p>
  
  <p>I need to run a formula in column C so i can check column A for "Petrol" and check corresponding rows in Column B for their value and then get a SUM of those numeric values as a total cost in column C</p>
  
  <p>Any help would be appreciated!</p>
  
  <p>Thanks</p>