How do you Sum a Column for multiple same date entries

Tim Levesque

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??

Paul Newcome

You are going to need to change your ranges up a bit.

=SUMIF({Other Sheet Date Column}, Date1, {Other Sheet Contracts Entered Column})

Dean Arvan

I think you need an equal sign next to the criterion part of the formula =SUMIF({Contract Entry Tracker total contracts}, = Date1) 

Tim Levesque

@Dean Arvan thank you for the suggestion. I tried that and still getting a 0

Paul Newcome

You are going to need to change your ranges up a bit.

=SUMIF({Other Sheet Date Column}, Date1, {Other Sheet Contracts Entered Column})

Tim Levesque

Thank you @Paul Newcome that did the trick

Paul Newcome

Happy to help. 👍️