3

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

Functionality
Formulas

Comments

Andree_Stara

Hi Steve,

Try something like this.

=SUMIFS({Contractor Invoice Upload Form Contract Inv Amount}, {Range - Date}, MONTH(@cell) = [email protected], {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

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 "[email protected]" is referencing? and the date {Range-Date}? does that mean i put the actual date range there?

thanks,

Steve