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

Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…
VLookup help
HI. I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula. example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…