How do you Sum a Column for multiple same date entries

I have the following sheet (tracker) that I am trying to total or sum if there are multiple entries for one day. Do you have any suggestions on formulas to use? So for the below, I am hoping to get 1 daily total for 7/14/20. I have tried to create a summary sheet and reference the data from this sheet but I cannot get the formulas to work. I tried the following on my summary sheet =SUMIF({Contract Entry Tracker total contracts}, Date1) and it gives me 0. The columns referenced in Contract Entry Tracker total contracts is Date and # Contracts Entered. Any Suggestions??

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!