Need help refining a formula where my outcome keeps coming out to 0

Gabriel Perez-Pujols

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.

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

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! 👍️