Ignore Spaces in "Blank" Cells

I have a cell with the formula =COUNTA('Survey Raw Data'!N2:N698) in it. On the "Survey Raw Data" worksheet, some of the cells in N2:N698 have a blank space entered into them (to stop 0 values from showing up elsewhere). Is there a way to make Excel NOT count those cells with blanks typed into them?

Try this:
{=SUM(--(LEN(TRIM(N2:N698))>0))}
i.e. type in =SUM(--(LEN(TRIM(N2:N698))>0)) then press ctrl shift and enter together.
TRIM removes any spaces, thus blank cells have LEN=0 all non-blank cells have LEN>0.
This gives a list of TRUE or FALSE for each cell in the range being blank or non blank, the -- forces EXCEL to interpret TRUE & FALSE as the numbers 1 and 0.
Thus the SUM instruction gives the count of all the non-blank cells.
pressing CTRL SHIFT and ENTER simultaneously tells EXCEL to process the instruction as an "ARRAY Formula".
Otherwise TRIM(N2:N698) will only return TRIM(N2) rather than the whole array of results for the entire range (and similarly for LEN etc.).
Mark

Originally Posted by NBVC

one way...

=COUNTA('Survey Raw Data'!N2:N698)-COUNTIF('Survey Raw Data'!N2:N698," ")

That worked - thank you!