• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Dear Solvers,


i got the answer for summing up of only even numbers in a series of data

but solver has used -- infront of MOD formula


can u please explain why the solver has put -- what is this ??
 
Hi,


This as been answered before, see this previous post from Hui...


http://chandoo.org/forums/topic/usage-of-2-hyphens-in-formula
 
Back
Top