So, I have a table with rows filled with scores, N/A, 0 (zeroes), and blanks, on different rows (depending on the row value in column A). Only one value appears in each column.

Since these values are scattered in different rows, I have one row above this table that sums each entire table column, to bring these values into one row.
I then plan on using these values on a chart.
The problem is, Excel takes the N/A's and outputs a 0 as the result of the =SUM(B2:B30) for example. and it also returns 0 as the sum of the blank rows.

I only want it to bring up the value on that cell, not sum it, but I don't know what formula would do that.

I have tried to use an IF statement, (if the sum <> 0 show the value, else show " "), and that works to an extent, but it doesn't deal with N/A's, blanks and zeroes. I need zero scores to count, but N/A or blanks to show that value also, so I already know =SUM is not the right formula.

What can I use instead?

Thanks!