title: loop in excel without using VBA or macros
body: <p>I have a table in Excel where I have categories and money like so:</p>
  
  <p><img src="https://i.stack.imgur.com/9tFSo.jpg" alt="enter image description here"></p>
  
  <p>I want to calculate the sum of all A category and B And C.<br>
  So I have to put a rule like this for the cell B1</p>
  
  <pre><code>=if(cell next B1 witch is A1="a";get B1)
  </code></pre>
  
  <p>and do the same for all other cells in B row.</p>
  
  <p>How can I get the total of money collected from category A  and from category B?</p>