title: Excel formula Inquiry Regarding Budget Tracker
body: <p><strong>Please note:</strong>  every single option I found online prior to this post were super complicated.</p>
  
  <p>I have decided to create my own budget tracker. I figure this will help me get a better handle on finances than what I've been doing (putting it into OneNote). Here is how I have my sheet setup:</p>
  
  <p><a href="https://i.stack.imgur.com/wB3rM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wB3rM.png" alt="enter image description here"></a></p>
  
  <p>Here is what I'm looking to do:</p>
  
  <ol>
  <li>Sum up the <strong>-</strong> columns if the <strong>Expected</strong> &amp; <strong>Monthly</strong> columns are <strong>Y</strong> or <strong>y</strong> (I can figure the annual once I get this one)</li>
  <li><p>sum up the <strong>-</strong> columns who have <strong>Y</strong> or <strong>y</strong> in their <strong>Business</strong> column (should be similar to 1, right?), but use the <strong>% of bill</strong> column as part of it, since some bills (like internet) are not just for business ... </p>
  
  <p>e.g.:  SUM <strong>Column L (Business)</strong> x (<strong>Column M (% of Bill)</strong> /
  100) where <strong>Column L</strong> is Y or y</p></li>
  <li><p>Sum up all rows in <strong>-</strong> who have <strong>EDU</strong> in <strong>Which fund</strong> column (I can figure out LTSS, GIV, FFA, and FUN from there)</p></li>
  <li><p>Sum all rows in <strong>+</strong> where <strong>Description</strong> is <strong>paycheck</strong></p></li>
  </ol>