
0
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
Comments
Andrée Starå
July 16, 2019 7:31 am
[email protected]…
July 16, 2019 8:54 am
Andrée Starå
July 21, 2019 5:44 am
In reply to im a little lost on the… by [email protected]…