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

Options
edited 07/14/20

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

• ✭✭✭✭✭✭
Answer ✓
Options

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

• ✭✭✭✭✭✭
Answer ✓
Options

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

• edited 07/14/20
Options

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!

• ✭✭✭✭✭✭
Options

Happy to help! 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!