Sum a range of cells without blanks

[if_Excel]

Looking for a formula that sums a range of cells say B2:B25 but ignores blank cells, N/A, Null. i have tried using SUMIFS with Isblank but i am not getting the construction right. thanks for the help

 

[T. Valko]

Looking for a formula that sums a range of cells say B2:B25 but ignores blank cells, N/A, Null. i have tried using SUMIFS with Isblank but i am not getting the construction right. thanks for the help

Try something like this...

=SUMIF(B2:B25,"<1E100")

 

[njimack]

Confirm with ctrl+shift+enter:
=SUM(IF(NOT(ISERROR(B2:B25)),B2:B25))

 

[if_Excel]

both formulas returned 0 and not the sum of the values

 

[T. Valko]

both formulas returned 0 and not the sum of the values

That means your values (numbers) aren't true Excel numeric numbers. They may be TEXT numbers which aren't the same as NUMERIC numbers.

See this for common data problems that lead to calculation troubles.

http://contextures.com/xlFunctions02.html#Trouble