# Date range formula

✭✭✭

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?

• ✭✭✭✭✭✭

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?

• ✭✭✭

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

• ✭✭✭✭✭✭

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

• ✭✭✭

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.

• ✭✭✭

Duh! Thank you.

• ✭✭✭✭✭✭

Happy to help! 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!