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

AVG COLLECT GREATER THAN VALUE
I have a formula to calculate the average amount within a sheet. I want to change the formula to only collect and average any amounts that are >£10,000. =AVG(COLLECT({Archive Sales Amount}, {Archive Sales Stage}, "4 - Closed Won", {Archive Sales Level 1}, "1")) Thinking I may need IF and @cell but it keeps giving me…
Counting Days with plus or minus options
I know, I know… use =Networkdays([start date]1, [end date]1) HOWever, I am trying to track the performance of when a job is completed according to its due date. I found adding a -1 to to stop the inclusiveness of the calculation, whereas I can get a job completed on 10/5 that was due 10/6 to show 1 day using…
Row with Multiple drop down choices and creating a summary
We have a Column on our Sheet which is a drop down list however more than one can be picked? Is there a way to as a summary to look for that field so that it sums it up? Below are 2 which are in a row and chosen from the drop down When we do the summary we would like this to be counted in both the IT Operations and Infra…