Sumifs, vlookup, or date range
Hey
I have some difficulty figuring out how to write a formula for my problem.
My scenario is as follows:
I have to sheets (see attached):
- Payment sheet
- Cashflow sheet
The payment sheet is used to log payments to sub-contractors. There are a date column and a column for each subcontractor. The last column sums the total paid to the sub-contractors on the specific date. The sub-contractors are being paid fortnightly.
The cashflow sheet is working on a monthly bases, so I would like to sum all the amounts in the last column of the payment sheet, based on the month in which the payments were made.
In the July 2019 column of the Cashflow sheet, I would like the sum of the amounts, in the payment sheet, paid in July.
Any ideas on how to write one formula in the cell of the cashflow sheet?
Kind regards,
Jana
Comments
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!