samedi 18 avril 2020

Google Sheet Checkbox Formula

I am trying to create sum conditions using a checkbox with 3 columns. I am just a beginner using google sheet any inputs and help will be much appreciated.

My forumla is: =SUM(M2189:N2189)-L2189+I2189,SUM(O2189,I2189)

If cell M and N is checked sum M and N - the total amount in L cell + I cell

Now I am getting an error on this part

If cell O is selected it should return 0 and the value from column I.

Thanks a lot.




Aucun commentaire:

Enregistrer un commentaire