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
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!