Using SUMIF to provide value of orders from this week only
Hi,
I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value.
=SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value})
The sheet references are to single columns titled 'Completion Date' and 'Order Value' respectively, but not sure what is not working as part of this?
Please could someone assist with this??
Comments
-
=SUMIF({Completion Date}, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()), {Order Value})
-
Thanks Luke; tried this, but got the invalid reference, as shown in the attached screen shot. Any thoughts as to what i'm doing wrong here?
-
Am I going crazy or do you have 3 periods in your formula?
-
Those aren't periods, but IDK what they are. Some sort of subscript. Try erasing the parethesis after today and retyping them.
Other than that you might have some data formatting issues in your references. Your formula is typed out correctly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 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!