Date range formula

JennS_

I want to sum the total cost of Down payments that are due within the next month, and I am pulling that into a roll up sheet. What formula would I use?

Paul Newcome

The last two entries in the report (top screenshot) do not fall within the date range. The date range of Today until 30 days from today ends on 25 March.

Paul Newcome

What exactly do you mean by "next month"? DO you want to sum up everything that is due in the next calendar month, or were you wanting to look out 30 +/- days?

JennS_

I want it to always look out 30 days from the current date.

Paul Newcome

Ok. You will want to use something like the below (following the appropriate steps to create cross sheet references):

=SUMIFS({Source Sheet Down Payment Amount Column}, {Source Sheet Down Payment Needed By Column}, AND(@cell >= TODAY(), @cell <= TODAY(30)))

JennS_

I am using the formula you suggested, but it is not pulling in all the correct cells.

=SUMIFS({Cabin SOW Summary Range 7}, {Cabin SOW Summary Range 5}, AND(@cell >= TODAY(), @cell <= TODAY(30)))

Below is the chart of total down payment amounts that equals the date range I am trying to total. This is a report that I am running to just show the upcoming SOWs and payments due from today thru the next 30 days. It should equal $1,294, 208. It is only pulling in $933

The above is the master sheet, that I am pulling the report from. I want to total down payment amounts from today thru the next 30 days.

Paul Newcome

The last two entries in the report (top screenshot) do not fall within the date range. The date range of Today until 30 days from today ends on 25 March.

JennS_

Duh! Thank you.

Paul Newcome

Happy to help! 👍️