Summing up only even numbers in a series of data !!

[senthilkumar_rm]

Dear Solvers,


I have a series of data where it consists of Odd and even numbers in A column

I would like to add(Sum) only the even numbers using a formula

 

[Sara]

Hi there,


Try this

=SUMPRODUCT(--(MOD(A1:A26,2)=0),A1:A26)


Regards

Sara

 

[senthilkumar_rm]

Can u please explain the formula

i dont understand -- infront of mod

 

[oldchippy]

Hi,


Refer to your other post


http://chandoo.org/forums/topic/sumproduct-moda1a2620a1a26

 

[bobhc]

senthilkumar_rm


Please do not double post a question, it is time wasting for forum members