Sum a range

Samuel Dowdy Jr.

I am trying to sum a column if the days past due are between 30-60. What formula would I use for this?

Paul Newcome

You would use something along the lines of:

=SUMIFS([Column to Sum]:[Column to Sum], [Date Column]:[Date Column], AND(@cell >= TODAY(-60), @cell <= TODAY(-30)))

Samuel Dowdy Jr.

I couldn't get it to work

sum "Invoice - Paid Variance" if "Days Past Due" is greater than 30 and less than 60

Paul Newcome

=SUMIFS([Invoice - Paid Variance]:[Invoice - Paid Variance], [Days Past Due]:[Days Past Due], AND(@cell >= 30, @cell <= 60))