COUNT and SUM formula for Summary on Parent Rows

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])


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!