MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Trouble with #N/A Using CSE formula to SUM

Posted by Jeremy Kaufman on January 30, 2002 9:09 AM

I am using the following formula. This sums all the "se" entries in L3:L143 correctly until it encounters #N/A. How do I sum all the "se" entries even if one "se" entry contains #N/A?


Posted by Mark W. on January 30, 2002 9:20 AM


Note: This is an array formula which must be
entered using the Control+Shift+Enter key
combination. The outermost braces, {}, are not
entered by you -- they're supplied by Excel in
recognition of a properly entered array formula.