SUMIF and Absolute Value

Hello,

I want to sum up the Project Remaining Hours of all "In Progress" projects. Sometimes I have negative project remaining hours, but I don't want to add the negative value.

How do I sum up the absolute value of the Project Remaining Hours in the formula below?

=SUMIFS({Project Remaining Hours}, {Project Status}, OR(@cell = "In Progress"))


Thanks,

Amy

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Amy Evans

    You can use @cell = "value" or simply use a comma between the {range} and the "criteria". The comma assumes an =.

    You would more likely want to use @cell when you want something other than =, such as <> (not equal to).

    The bit that's not necessary is the OR function. You only have one value you're looking for, so you don't need to look for "this" or "that", does that make sense?

    Cheers!

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers