Hello,
Thank you for your help in advance.
I am trying to SUM a $ Amount that has rows with multiple $ amounts but same value. Please see example below.
I have tried countif to label the duplicates and then sumif based on what was tagged as a duplicate and what wasn't but can not get it to work.
Thank you for your help in advance.
I am trying to SUM a $ Amount that has rows with multiple $ amounts but same value. Please see example below.
I have tried countif to label the duplicates and then sumif based on what was tagged as a duplicate and what wasn't but can not get it to work.
Value | $ Amount | Needed Results |
911 | $4,897.00 | $4,897.00 |
921 | $2,945.00 | $2,945.00 |
955 | $19,953.50 | $0.00 |
955 | $1,273.00 | $21,226.50 |
956 | $2,380.00 | $0.00 |
956 | $1,767.00 | $0.00 |
956 | $1,836.00 | $5,983.00 |
974 | $9,923.00 | $9,923.00 |