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
-
You are going to need to change your ranges up a bit.
=SUMIF({Other Sheet Date Column}, Date1, {Other Sheet Contracts Entered Column})
Answers
-
I think you need an equal sign next to the criterion part of the formula =SUMIF({Contract Entry Tracker total contracts}, = Date1)
-
@Dean Arvan thank you for the suggestion. I tried that and still getting a 0
-
You are going to need to change your ranges up a bit.
=SUMIF({Other Sheet Date Column}, Date1, {Other Sheet Contracts Entered Column})
-
Thank you @Paul Newcome that did the trick
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!