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

--
__________________________________
HTH

Bob

"vlook fomula" wrote in message
...
i have different data in different column and i want to calculate the
alternate cell/column then how i can apply this

regards
Zafar