Invalid Operation

Good morning,

I am trying to sum the entries that are greater than 30 but less than 60 days old.

=SUMIFS({011-AP Archive -# of Days to Complete}, >30, {011-AP Archive -# of Days to Complete}, <60)

I was able to do this same formula with a COUNTIFS but its' not working the same, what am I missing.

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    edited 06/16/23 Answer ✓

    Try this:

    SUMIFS({011-AP Archive -# of Days to Complete}, {011-AP Archive -# of Days to Complete}, > 30, {011-AP Archive -# of Days to Complete}, < 60)

    With SUMIFS, you have to include the range to SUM separately from the ranges to compare. In your scenario, they are the same, but can be different.

    SUMIFS( range, criterion_range1, criterion1, [ criterion_range2, ​criterion2​... ])

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    edited 06/16/23 Answer ✓

    Try this:

    SUMIFS({011-AP Archive -# of Days to Complete}, {011-AP Archive -# of Days to Complete}, > 30, {011-AP Archive -# of Days to Complete}, < 60)

    With SUMIFS, you have to include the range to SUM separately from the ranges to compare. In your scenario, they are the same, but can be different.

    SUMIFS( range, criterion_range1, criterion1, [ criterion_range2, ​criterion2​... ])

  • AliT
    AliT ✭✭

    Thank you! That was the trick!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!