Tag Info

Hot answers tagged


With the new Google Cloud Console the procedure to obtain the P12 key has changed: Open the project, go to APIs & auth > Credentials Click on Create new Client ID, and select Service account and P12 key. Then click on Create Client ID to download it.


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