Looping with SUMIF function

[Marilyne]

I have two columns

Column A from 1 to 10
Column B from 1 to 10

I want to compare each cell of A with B and SUM the value of A if they are different from the value of B.

If A1 <> B1 Then Add A1
If A2 <> B2 Then Add A1 et A2 .....

I'm a beginner so your explaination must be easy and clear!

Thank you very much for your help

 

[Ken Wright]

=SUMPRODUCT((A1:A10<>B1:B10)*(A1:A10))

 

[J.E. McGimpsey]

One way:

=SUMPRODUCT(--(A1:A10<>B1:B10),A1:A10)