How to SUMIF(S) Date Range

Options
Neree Jackson
Neree Jackson ✭✭✭
edited 07/15/20 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!