Formula Assistance (SUMIFS, COUNTIFS of CHILDREN)

CHealy
CHealy
edited 12/09/19 in Formulas and Functions

I'm having difficulty with a few formulas wherein I'm attempting to SUM and COUNT only the CHILD rows so as to not duplicate amounts or counts (ie. need to exclude the Parent Row). 

The formula below works when the BOLD text is not inserted.

The issue is that the potential exists where the sum and/or count will include the Parent Row. 

I’m trying to find a workaround for that, for both SUMIFS and COUNTIFS. 

=COUNTIFS(CHILDREN(@{TEAM Completed Estimates Status}, "Won", {TEAM Completed Estimates Estimator}, FIND("John Smith", @cell)>0))

=SUMIFS(CHILDREN(@{TEAM Completed Estimates Project Sell Price}, {TEAM Completed Estimates Status}, "Won", {TEAM Completed Estimates Estimator}, FIND("John Smith", @cell)>0))

Can you assist?

Tags:
«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!