Need help refining a formula where my outcome keeps coming out to 0
For one of my formulas, I am using three columns; a date column (Week Begin) , name column, and number column (total inbound). I am trying to sum certain values in the total inbound column based on the name associated with the data and date range (one week).
I am using the formula: =SUMIFS([Total Inbound]:[Total Inbound], [Name]:[Name], ="support", [Week Begin]:[Week Begin], OR(@cell = "06/22/20", @cell = "06/29/20"))
Unfortunately, the formula only seems to return a "0" regardless of how I manipulate the data.
I wasn't entirely sure how to word this question so if there is a need for clarification, I will do my best to be a little more specific.
Best Answer
-
It is how you are entering your dates. Try this...
=SUMIFS([Total Inbound]:[Total Inbound], [Name]:[Name], ="support", [Week Begin]:[Week Begin], OR(@cell = DATE(2020, 06, 22), @cell = DATE(2020, 06, 29)))
Answers
-
It is how you are entering your dates. Try this...
=SUMIFS([Total Inbound]:[Total Inbound], [Name]:[Name], ="support", [Week Begin]:[Week Begin], OR(@cell = DATE(2020, 06, 22), @cell = DATE(2020, 06, 29)))
-
Thank you so much @Paul Newcome!! I was trying to work over this for the longest time and I never realized it was due to how I was inputting my data. You're the best!
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!