Trying to Sum Rows that Contain 'Countif' formulas

Cinda.q

Has anyone had any trouble counting rows that contain a countif formula?  I have tried to sum all corresponding cells and have also tried to count all the children lines and the value does not calculate correctly. My values within the children lines do contain some 0 values but there are no blank lines. Any suggestions?

Paul Newcome

Try wrapping your COUNTIF statements in a VALUE function.

 

=VALUE(COUNTIF(................................))