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

and copy across for qty

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"vlook fomula" wrote in message
...
how i do apply a formula at alternate cell , while i have 30 number of
column
such as
Pakg. qty. pakg. qty total Pack. total. qty
2 200 3 600 ? ?

Regards
Zafar