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?


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Abbie G

    Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Garrett Henke
    Garrett Henke ✭✭✭✭✭

    Hi Abbie,

    Use DISTINCT() to only count unique values for your projects

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!