Summing only cells that have data and ignoring cells that have#DIV/0! in them

[rbrown999]

I have a spreadsheet that acts as a template. Because of that, there
may be data in rows 2-10, but nothing below row 10. Data in columns A
through Z feed formulas in columns AC through AL. Prior to putting
any data in columns A through Z, the formulas in columns AC through AL
are all showing #DIV/0! because of course there's no data in the cells
those formulas are looking in.

I want to sum the totals of some of the columns that in AC through AL,
but of course if I only have data in rows 2-10, then the #DIV/0!
message in the rows below 10 will not allow me to sum the entire
column. I could just pull the formula down to the rows that have
data, but I want to share this spreadsheet with others besides me.

I want to create a formula that looks in a column (let's use column AC
for these purposes) and sums only cells that have a number in them and
ignores cells that contain the #DIV/0! error message.

TIA,
Robert

 

[T. Valko]

Try this:

=SUMIF(AC:AC,"<=1E100")