SUMIF and Absolute Value


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"))



Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    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?