Sumif amt is equal to specific date

Kathy Morgan

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?

Nic Larsen

Something like this would work for a specific date in a range of dates:

=SUMIFS([$amt]:[$amt], Dates:Dates, DATE(2020, 12, 3))

Kathy Morgan

Thank you, I was using slashes.