I have a Google spreadsheet with cells having the following format:
A1: 1 Y A2: 0.5 N A3: 2 N A4: (empty) A5: (empty) A6: 1.3 N
I would like to sum the numbers in the cells, i.e. (1+0.5+2+1.3) while ignoring empty cells.
This is the formula I'm using right now, but it does not work with empty cells:
This is the error I get in Google Sheets:
Function FIND parameter 2 value should be non-empty.
How I can modify this formula to ignore empty cells?