title: I need help finding a formula to format my Excel database
body: <p><img src="https://i.stack.imgur.com/042n5.png" alt="Picture" /></p>
  <p>Excel doesn't count my records like I want it to. I have been trying for a while now.</p>
  <p>Example</p>
  <pre><code>School        6
  Work          5
  TV            3
  School        2
  </code></pre>
  <p>I have a formula that counts the numbers, so I have a total now. which is 16.
  What I want is to have a formula that counts the hours for each term</p>
  <p>So when I write</p>
  <pre><code>School
  Tv 
  Work
  </code></pre>
  <p>I want to get the hours for each of these.</p>
  <p>So instead of counting the number of &quot;school&quot; that is in the document, I want it to calculate ALL numbers even if school is in there like 10 times.</p>
  <p>In this case my expected output would be</p>
  <pre><code>School 8
  TV     3
  Work   5 
  </code></pre>
  <p>I've been searching for the formula to do this...</p>
  <p>So I'll try to explain again: I have 2 fields, one containing terms the other containing numbers. I need a formula that counts the sum of numbers for each term in the fields with terms. EVEN IF the term is in there twice than it is supposed to count the values and add it up to each other... By doing this I will be able to create a graphic.</p>
  <p>UPDATE</p>
  <p>Maybe the picture will help understanding it better</p>