Add only cells with number value

[mactoolsix]

I have 10 columns AC thru AL. Some of these cells contain a formula returning blank "" and some contain numbers.
I need to add up only columns AC, AD, AK & AL when those cells contain a number - I need to skip if they are blank "" cells.

Simply adding AC+AD+AK+AL returns an error as some are "" blank cells.
If I use IFERROR then nothing is added as there is always a couple of "" blank cells.

Attempted to use SUMIF(AC+AD+AK+AL,"<>",AC+AD+AK+AL), however it returns a #VALUE ! error.

Would appreciate any help . . .
Mike

 

[Fazza]

try SUM

 

[mactoolsix]

SUM returns a #VALUE ! error as some of the cells may contain a blank "" formula.

 

[Rick Rothstein]

SUM returns a [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=VALUE]#VALUE [/URL] ! error as some of the cells may contain a blank "" formula.

That is not the reason you are getting the #VALUE ! error... truly empty cells as well as cells containing text or formulas returning text (including "") are ignored by the SUM function. Are any of the cells in you ranges displaying a #VALUE ! error? If not, are you attempting to add 0 to your ranges inside the SUM function (doing that would make a cell return a #VALUE ! error as you cannot add a number to non-numerical text)?