# Formula for date range

Options
edited 12/09/19

I am trying to calculate the total amount of invoices, from a given contractor, within a given date range.

Im not sure how to write a formula to calculate within a specific date range.

I have the formula to calculate the total invoices for an individual. But not sure how to insert date range into the formula.

Here's where im at so far...

=SUMIFS({Contractor Invoice Upload Form Contract Inv Amount}, {Contractor Invoice Upload Form Contractor Name}, [Contractor Name]@row)

thanks for you help

Steve

Tags:

• ✭✭✭✭✭✭
Options

Hi Steve,

Try something like this.

=SUMIFS({Contractor Invoice Upload Form Contract Inv Amount}, {Range - Date}, MONTH(@cell) = Month@row, @{Contractor Invoice Upload Form Contractor Name}, [Contractor Name]@row)

Hope that helps! Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

im a little lost on the formula. i included a screenshot of the sheet im referencing for dates and amounts of invoices to see if you might be able to help clarify for me...I have a column (reference screen shot) called invoice date. This is the column where i need to pull a date range from.

Im not sure where the "month@row" is referencing? and the date {Range-Date}? does that mean i put the actual date range there?

thanks,

Steve

• ✭✭✭✭✭✭
Options

Happy to help!

Sorry! I should have been more clear.

Range - Date = The Invoice Date Column.

Month@row = A new column that you'd add to the roll-up sheet. You could change it to the month number instead of the @row if you prefer.

Hope that helps!

Did you get it working?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!