How to SUMIF(S) Date Range
I have been trying to sum the total length of contacts within a date range and I can't figure out how to make it work.
I have been successful summing have of the problem, but can't seen to find a way to make them work together:
=SUMIF(CHILDREN([Date Start]58), >=[Date Start]4, CHILDREN([Length of Contact]58))
=SUMIF(CHILDREN([Date Start]58), <=[Date End]4, CHILDREN([Length of Contact]58))
This formula "works" but produces an answer of zero, which is incorrect:
=SUMIFS(CHILDREN([Length of Contact]58), CHILDREN([Date Start]58), >=[Date Start]3, CHILDREN([Length of Contact]58), CHILDREN([Date Start]58) <= [Date End]3)
Any idea what I am doing incorrectly?
Answers
-
Give this one a go...
=SUMIFS(CHILDREN([Length of Contact]58), CHILDREN([Date Start]58), >=[Date Start]3, CHILDREN([Date Start]58), <= [Date End]3)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!