Google Spreadsheet, Sum if cells contain specific text
<p>I would like to reduce another cell by 34 if a certain cell equals "home"</p>

<p>I currently have which ignores any cell that isn't more than 0. but I also need to reduce it by another 34 if we played at home:</p>

<pre><code>=sumif(D2:D20, "&gt;0")
</code></pre>