I've tried using SUM and SUMIF but it's returning a value of zero and there are values in the range.
So the SUMIF formula I tried looks like this; =SUMIF('2014'!N3:N196,">0"), so on the 2014 sheet I want all the cells that are not blanks to return the sum. The SUMIF needed a criteria argument, so I included the >0.

The SUM formula I tried was simply; =SUM('2014'!N3:N196)

Both return a value of 0.00

The range N3:N196 contains numbers in some cells and blanks in others. There is no text.
I think one or both of these formulas should work but neither is.

Any ideas.