title: Excel Function or VBA needed to Sum Values of Rows with Identical Part Numbers
body: <p>Need help, I have a huge sheet with manufacturer, part number, quantities, and some other information give. I think I'm looking for a VBA script that will produce a new row with sums of rows with identical part numbers. So in a &quot;Totals&quot; table I want the first row to show but to show with a quantity of 10, combining rows 1 and 5. Is this easier to do in a pivot table? I assumed this wouldn't be too bad to do in VBA but I'm lost. In the information given below, each group is it's own column, so Dell is A, Computer is in D. Thanks!</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>A</th>
  <th>B</th>
  <th>C</th>
  <th>D</th>
  <th>E</th>
  <th>F</th>
  <th>G</th>
  <th>H</th>
  <th>I</th>
  <th>J</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Dell</td>
  <td>54551AJDJF6</td>
  <td>3</td>
  <td>Computer</td>
  <td>Electrical</td>
  <td>$52.30</td>
  <td>Robert</td>
  <td>4/12/2019</td>
  <td>5/5/2020</td>
  <td>PO125</td>
  </tr>
  <tr>
  <td>Dell</td>
  <td>2664664HG7</td>
  <td>8</td>
  <td>Computer Screen</td>
  <td>Electrical</td>
  <td>$142.00</td>
  <td>Robert</td>
  <td>4/12/2019</td>
  <td>5/5/2020</td>
  <td>PO125</td>
  </tr>
  <tr>
  <td>Dell</td>
  <td>165165DFF7</td>
  <td>4</td>
  <td>Keyboard</td>
  <td>Electrical</td>
  <td>$52.17</td>
  <td>Robert</td>
  <td>4/12/2019</td>
  <td>5/5/2020</td>
  <td>PO125</td>
  </tr>
  <tr>
  <td>Dell</td>
  <td>2664664HG7</td>
  <td>1</td>
  <td>Computer Screen</td>
  <td>Electrical</td>
  <td>$12.68</td>
  <td>Robert</td>
  <td>4/12/2019</td>
  <td>5/5/2020</td>
  <td>PO125</td>
  </tr>
  <tr>
  <td>Dell</td>
  <td>54551AJDJF6</td>
  <td>7</td>
  <td>Computer</td>
  <td>Electrical</td>
  <td>$23.21</td>
  <td>Robert</td>
  <td>4/12/2019</td>
  <td>5/5/2020</td>
  <td>PO125</td>
  </tr>
  </tbody>
  </table>
  </div>