Adding a column of formulas

[hotrod]

How do I add a column of cells with formulas without getting #DIV/O! for the total?

 

[VoG]

If it is giving zero you haven't entered it as an array formula. With the cell with that formula selected click in the formula bar, hold down CTRL and Shift and press Enter.

 

[T. Valko]

Try this:

=SUMIF(B5:B56,"<1E100")

 

[hotrod]

Thank you #NAME? =SUMIF(B5:B56,"<1E100") works, problem solved.

Peter =SUM(IF(ISNUMBER(A1:A10),A1:A10)) still not able to get this to work for some reason. Have tried numerous times. I put in the formula =SUM(IF(ISNUMBER(A1:A10),A1:A10)) selected Ctrl Shift Enter like you said and it changes to {=SUM(IF(ISNUMBER(A1:A10),A1:A10))} but the total is always 0.
Thanks for the suggestion, I'll keep this one in mind for future problems.