Formula at alternate Cell Values

  • Thread starter Thread starter vlook fomula
  • Start date Start date
V

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