sumproduct

vlook fomula · Jul 21, 2008

i have different data in different column and i want to calculate the
alternate cell/column then how i can apply this

regards
Zafar

Bob Phillips · Jul 21, 2008

=SUMPRODUCT(--(MOD(COLUMN(A2:M2)-COLUMN(A2),2)=0),A2:M2)