SUMIF that include unique values?

=INT(SUMIFS({Value}, {Sheet}, "GLS", {Lease Exp. Date}, AND(@cell >= DATE(YEAR(TODAY()) - 2, MONTH(TODAY()), DAY(TODAY())), @cell <= TODAY())) / 1000000)

It's adding repeated projects, such as AO987. There can be 3 AO987 which is $78,000, but instead of counting it 3 times, I need it to only count it once. How do I sum unique values?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!