sumproduct

[vlook fomula]

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]

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