Formula at alternate Cell Values

[vlook fomula]

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

 

[Bob Phillips]

=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)

 

[Max]

Assuming package # in A2, C2, E2, quantity # in B2, D2

Sum (package #):
=SUMPRODUCT((MOD(COLUMN($A:$E),2)=1)*A2:E2)

Sum (quantity #):
=SUMPRODUCT((MOD(COLUMN($A:$E),2)=0)*A2:E2)

Extend to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik