title: How to sum multiple repeated values just once
body: <p>Column A/B are 2 different part numbers.</p>
  <p>Column O is the value for those.</p>
  <p>Each value in column O is being repeated multiple times.
  <a href="https://i.stack.imgur.com/GIOdj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GIOdj.png" alt="Data" /></a></p>
  <p><strong>What I am looking for</strong> - I am looking for a formula which can help sum all the values but just counting them as once. For example it should be 2+20 irrespective of how many times it is being repeated with respect to both Column A and B
  <a href="https://i.stack.imgur.com/lRKri.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lRKri.png" alt="Result" /></a></p>
  <p><strong>What I tried</strong> - I tried a combination of SUMIF and SUMIFS but didn't work. It would just sum all the values.</p>
  <p>Thanks</p>