SUM(IFERROR(INDEX(COLLECT(MATCH))))
I may have just the brackets wrong or overthinking this but I need to return the SUM of column 'eOEM' when the 'Date of report' column is in the next 7 days AND the 'transaction status' column is "New". The formula I have is =SUM(IFERROR(INDEX(eOEM:eOEM, COLLECT(MATCH("New", [Transaction Status]:[Transaction Status], TODAY(7), [DATE OF REPORT]:[DATE OF REPORT], )), 0,""))) … can anyone help please?
Also trying =SUMIFS(eOEM:eOEM, [Transaction Status]:[Transaction Status], "New", [DATE OF REPORT]:[DATE OF REPORT], TODAY(7)) which doesn't work
I also cannot upload the small jpg screenshot to show this by copy and pasting, attach image or add attachment options.. just keeps crashing MS Edge!
Best Answer
-
Try this:
=SUMIFS(eOEM:eOEM, [Transaction Status]:[Transaction Status], "New", [DATE OF REPORT]:[DATE OF REPORT], AND(@cell >= TODAY(), @cell <= TODAY(7)))
Answers
-
Try this:
=SUMIFS(eOEM:eOEM, [Transaction Status]:[Transaction Status], "New", [DATE OF REPORT]:[DATE OF REPORT], AND(@cell >= TODAY(), @cell <= TODAY(7)))
-
YOU ARE A SUPERSTAR!!! THANK YOU SO MUCH :)
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!