Hot answers tagged google-apps
I always use the ISNA() function. As a first step, I create the range with filter(): =FILTER( TRANSACTIONS! C4:C51; TRANSACTIONS! D4:D51="Other"); As a second step, I always use the: =IF(ISNA(range);0;thingsToDoWith(range)); So, in your case it will become: =IF(ISNA(FILTER( TRANSACTIONS! C4:C51; TRANSACTIONS! D4:D51="Other"));0;SUM(FILTER( ...
Only top voted, non community-wiki answers of a minimum length are eligible