I am trying to get a sum of column values in a Google Spreadsheet only if there is no value in the adjacent column. Consider the following example:
A | B ------- 40 | 50 20 | 20 30 | 10 |
The sum of
A should return 40.
I tried to use the following function:
but all I get is:
Error: Unknown function name ISEMPTY. Can anyone tell me what's wrong or how to do it properly?