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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!