title: How to sum 2 line in VBA with conditions
body: <p>I have a hard problem that I can't resolve in VBA.
  I explain you with a simple example :</p>
  <p><a href="https://i.stack.imgur.com/VcnUL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VcnUL.png" alt="database" /></a></p>
  <p>I have this database in excel.
  my aim is to sum value of apple and apple_1 for column 1,2,3  but for column 4, I want put 1  IFI have just one value who is 1 and 0 IF the 2 value ( apple and apple_1) are 0.</p>
  <p>of course, I can have sometimes apple_2 apple_3 apple_4 ...  ( I just take an easy example)</p>
  <p>Here an example of what I want with VBA :</p>
  <p><a href="https://i.stack.imgur.com/6oGjx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6oGjx.png" alt="final_result" /></a></p>