If there are duplicate values in "Column A" I only want to sum the cost where Column B has "Final"
In the example below I only want to sum the Cost values that are in yellow text
In the example below I only want to sum the Cost values that are in yellow text
Job # | Adjust | Cost |
71D0001 | 75%-95% | 3,073,284 |
71D0001 | Final | 3,097,975 |
71D0032 | 75%-95% | 933,248 |
71D0032 | Final | 923,708 |
71D0044 | 75%-95% | 548,985 |
71D0044 | Final | 571,565 |
71D0051 | 75%-95% | 704,370 |
71D0056 | 75%-95% | 206,801 |
71D0050 | 522,270 | |
71D0057 | 878,609 | |
71D0058 | 1,301,725 | |
71D0060 | 1,196,818 | |
9,403,841 |