SUMIF that include unique values?

Options

=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?

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    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

    bassam.khalil2009@gmail.com

    ☑️ 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 ✭✭✭✭✭
    Options

    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!