Need help with a formula to sum all numbers in a column that have the same date?
Hi there --
I'm working on a project where I need to track the total number of hours a person worked each day. A person may have three rows (log entries) with the same date, so I'd like the formula to count the hours column for each row that has the same date.
In the example above, the Total column would show the total number of hours for the day For example, the three rows that have 10/1/23 would show "8" in the Total column.
I'm using the formula =SUMIFS(Hours:Hours, Date:Date, @cell) but it's returning an "Invalid Data Type" error. I can't quite figure out what's causing the error. Any ideas?
Thank you!
Best Answers
-
Hi @jmhoward ,
You're super close, try this.
=SUMIF(Date:Date, Date@row, Hours:Hours)
Hope this helps,
Dave
-
Ah! Thank you @jmyzk_cloudsmart_jp and @DKazatsky2 ! That was driving me crazy. I neglected to account for those blank rows.
I really appreciate the help!
Answers
-
Hi @jmhoward ,
You're super close, try this.
=SUMIF(Date:Date, Date@row, Hours:Hours)
Hope this helps,
Dave
-
Hi @jmhoward
If you remove all the blank rows, your formula should work; otherwise, add ISDATE(@cell).
=SUMIFS(Hour:Hour, Date:Date, ISDATE(@cell), Date:Date, Date@row)
-
Ah! Thank you @jmyzk_cloudsmart_jp and @DKazatsky2 ! That was driving me crazy. I neglected to account for those blank rows.
I really appreciate the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!