title: Match string in column and sum corresponding rows
body: <p>I have this issue that I'm trying to solve with VBA. </p>
  
  <p><strong>Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/mZ5t8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mZ5t8.png" alt="Table Example"></a></p>
  
  <p>There is only 1 sheet in the workbook. </p>
  
  <p><strong>Expected Solution</strong></p>
  
  <p>I'm trying to perform a string search for <strong>column A</strong>, such that if it is A75X (where X is any number), I want to sum up the corresponding A75X values under <strong>column C</strong>, and replace the A75 column C blank with the summed value. </p>
  
  <p><strong>Expected Output</strong></p>
  
  <p><a href="https://i.stack.imgur.com/rDWyR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rDWyR.png" alt="Expected Output"></a></p>