Invalid Operation

AliT

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.

Carson Penticuff

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​... ])

Carson Penticuff

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

Thank you! That was the trick!!