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