Sum Children() If Date <=today()

Kurt Mostrom

I'm trying to create a fomula that will sum the TOTALS column for all the Children() of a parent row that the DATE <=Today().  Any thoughts?  

J. Craig Williams

Kurt,

 

You are looking for the SUMIF formula

 

This goes in the parent row's TOTALS column

 

=SUMIF(CHILDREN(DATE23), <=TODAY(), CHILDREN())

 

assuming your date column is named [DATE] and the row is 23

 

Hope that helps

 

Craig