Should be simple I thought
I have tried what I thought should be a simple formula two or three different ways. Here is the basis of the requirement.
Multiple Months, Multiple Vendors with multiple invoices within a month, Multiple projects that some of the vendors bill to and others do not.
For the purpose of this exercise, I need to get the invoice total by month and vendor. I am able to do this in the summary for the Invoice Sheet, but for some reason cannot bring the same logic into the Budget / Forecast Sheet.
There are two sheets involved one is the Invoice Sheet where the "Invoice Total", "Vendor ID", and "Svc Month" are located. The other sheet is the Budget sheet where Month over Month Total by Vendor should be, which includes "Vendor ID", and columns for each month, e.g., "Aug 2023"
any assistance would be very much appreciated at this point as I am now at a loss.
Best Answer
-
Try removing a closing parenthesis from the formula above.
Answers
-
Try removing a closing parenthesis from the formula above.
-
Paul, thank you. I knew I had been looking at this thing too long. Worked perfectly.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!