COUNT and SUM formula for Summary on Parent Rows

laura.sandoval

Hello! I am looking to fix a formula that came with one of the templates I found. The Summary section on the top I want to summarize the total contracts and total contract value...but I added parent rows to the bottom half.

What should I change in the formula for it not to include the parent rows in the sum?

Total Contracts Formula

=COUNT([Contract # / SOW / Quote Number]:[Contract # / SOW / Quote Number])

Total Contract Value Formula

=SUM([Contract Amount]:[Contract Amount])

Samuel Mueller

@laura.sandoval You need a helper column that has a formula something like

=count(children()) and make it a column formula

then in your sum formula it would be something like

=SUMifs([Contract Amount]:[Contract Amount],[helperrow]:[helperrow],0)