search

odoo / o-spreadsheet

Other
192 stars 44 forks source link

possibility to use formulas also in case of errors #4526

Open dberardo-com opened 3 months ago

dberardo-com commented 3 months ago

i have got this situation and would like to create a sum function that can ignore #ERROR cells:

image

as in =MY_SUM(A1:A6) --> return sum ignoring #ERROR cells

is this possible at the moment ?