How to SUMIF(S) Date Range

Neree Jackson

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?

Paul Newcome

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)