Formula for date range

steve50951

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

Andrée Starå

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

steve50951

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

Andrée Starå

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?