Table:
1 2 3 N 4
N N 2 4 5
1 2 3 4 5

I want to sum each row and expected results are NA, NA, 15 for 1st,
2nd and 3rd row, respectively.

I used IF(ISNUMBER(A1:E1),SUM(A1:E1),"NA") and then shift+ctrl+enter.
but seems the results are not correct. It always give me 6,11,15..:(

any mistake here?

thanks.

yy