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.

Find more posts tagged with

Accepted answers

Paul Newcome

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)))

All comments

Paul Newcome

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)))

Gabriel Perez-Pujols

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!

Paul Newcome

Happy to help! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.