Excel: Search Project List, Return Number of Hours Per Project
<p>I have two columns:</p>

<ul>
<li><strong>Column A</strong> which contains Project Names</li>
<li><strong>Column B</strong> which contains hours.</li>
</ul>

<p>Information in <code>Column A</code> is duplicated, for example: <code>Project X</code> may appear 7 times.</p>

<p>How can I come up with the total number of hours for each project?</p>