Sumif amt is equal to specific date

Kathy Morgan

Kathy Morgan ✭

12/03/20 in Formulas and Functions

I am trying to total $amt to a specific date. I can get it to sum a whole month however I cant get it to total a specific date.

Can anyone help?

0 ·

Answers

Nic Larsen ✭✭✭✭✭✭

12/03/20

Something like this would work for a specific date in a range of dates:
=SUMIFS([$amt]:[$amt], Dates:Dates, DATE(2020, 12, 3))

0 · Share on Facebook Share on Twitter
Kathy Morgan ✭

12/04/20

Thank you, I was using slashes.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula need to return Pass/Fail if 1 of multiple cells are blank
Hi, I am trying to put a formula together that will provide a fail if any part of the address or the phone number hasn't been provided. The below formula only provides fail if all cells are blank. I have tried other variations, this is the only one that does not give me some sort of error. =IF(OR(NOT(ISBLANK([Street…
CountIf Function
I want to count the number of each option in this example; Change Router, Upgrade, Disconnect. My Objective column is set up as a drop down with allow multiple values enabled. My formula is only calculating Row 5, because that is the only row with only one value. How do I get my formula to calculate each drop down option…
Formula to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.