SUMIF that include unique values?

Abbie G

=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

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.

Garrett Henke

Hi Abbie,

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