Help with a Debit Credit Table

ok, first off just a little background. I work with a Civil Engineer in Tallahassee, Florida. For every project we do we need to provide the city a "Tree Debit/Credit table. the table itself is not very complicated. it's actually very basic. the problem is when we run into a project that has a ton of trees on the site. the table breaks down into 3 maybe 4 parts. the first part of the table is just telling if the tree is protected. anything over 17 inches is considered a protected tree. the second part of the table has to deal with tree removal and the debits or credits that go along with the tree removal. this part is based on the size of a tree. a tree that is lets say 2" gets a value assigned to it. this is the "credit" so to speak that we are given if the tree remains. if the tree is removed then a debit is given. pretty basic, i know. what this determines though is the extent of the landscaping required. i have used a lookup formula for the debits/credits in the "Tree Value" portion of the attached file and an "IF" statement in the "Credit" "Debit" portion of actual table that will be submitted. the 3rd part of the table though is giving me problems. i know it is a format error but can not figure out how to get the "Totals" for the "Credit" and "Debit" portions of the table. If anybody could help me with this problem the help would be most appreciated.

To say my knowledge of Excel is limited is a vast understatement. i mean i can understand what the formula does, once written but actually making them all play nice together is where i stumble and fall flat on my face.

First, in your column Z, you use:

Please Login or Register  to view this content.

Recommmend you change this to:

Please Login or Register  to view this content.

This will allow Excel to sum the result instead of treating it as text.

Second, your credit total formula in the F18 cell is:

Please Login or Register  to view this content.

You can reduce this to:

Please Login or Register  to view this content.

The same may be done with the other credit/debit total cells.

Cheers,