Trending in Formulas and Functions
-
Sum Multiple Criteria
I'm looking to sum the total in the CS Error Cost column anytime the Responsibility column equals CSC, ISG or UAL. I've attempted different nesting versions of the SUMIF and SUMIFS but keep getting an error. Below is one example of what I attempted. =SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility,…
-
IFERROR Formula Not Working
Good day, team. I have a formula that works as intended, which takes the latest row of children data and inputs that as the value. That formula is: =(INDEX(CHILDREN(), COUNT(CHILDREN()))) and produces the following results: However, if there is no data in the children cells it gives me an "Invalid Column Value" as shown…
-
Sum of child rows multiplied by other row.
Hello Community, Can the sum of child rows that are individually multiplied be achieved without the use of a helper column? I would like to be able to detail the total sum of the child rows [March 2025] multiplied by [Rate] without the use of a helper column. I =SUM(CHILDREN([March 2025]@row ) * CHILDREN(Rate@row ))…
