I am trying to create a formula for the Total cell at the bottom of a column. The problem is that some of the values in the blocks I am adding up are N/A values. (All the values in the blocks are also formulas themselves, with IF statements).

No matter what we have tried so far, we can't get the Total cell to calculate the total. We have tried the following:

`SUM(IF(ISNA(A1:A4),0,A1:A4))`

`SUMIF(A1:A4,"<>#N/A")`

Is it because the cells we are calculating a total for are formulas themselves? What are we missing?

`=SUMIF(A1:A4,"<>#N/A")`

? – Raystafarian Oct 3 '14 at 12:35