How to add a range of cells that include #nun

[sunboy]

Hi

I am kindly asking for a formula to sum a range of cells that include #NUM. I have attached the excel sheet.

Thank you.

Regards,

Sunboy

[Sam Capricci]

this is one way... {=SUM(IF(ISERROR(C2:C13),"",C2:C13))}
NOTICE that it is an array so this part =SUM(IF(ISERROR(C2:C13),"",C2:C13)) is entered in the cell, then while in the formula bar you click on ctrl & shift & enter at the same time and the {} will appear on each end of the formula. You cannot add them on your own.

[sunboy]

Hi Sam Capricci

Thank you.

Regards,

Sunboy

[Sam Capricci]

You're welcome, AND thank you for the rep!