title: SUMIF a cell on the same row, in a certain column, contains a specific text
body: <p>I'm trying to sum all transactions on a spreadsheet of my bank statement. Let's say I have the following under columns B-F:</p>
  
  <pre><code>         B        C             D            E          F         G
          Date    Type       Transaction      Value     Balance    ???
  row 4 23/05/14  BAC      Bank transfer A   1103.55    637.03
  row 5 23/05/14  POS      Pizza purchase    10.00      627.03
  row 6 23/05/14  POS      Coffee purchase   10.00      627.03
  </code></pre>
  
  <p>I'd like to make a new cell on column G which sums all values in column E that are on rows containing "POS" in column C. Is this possible?</p>