title: Excel - Finding all Values within a Selection
body: <p>I'm looking for a way for Excel to find all the values of one instance, such as "ABC" in a certain range and then return and sum the corresponding values. </p>
  
  <p>I've been looking at VBA functions that do this, but is there a more simple way? </p>
  
  <p>thanks!</p>