Data Total for different column

Dear Dxpert

I have some data as Qty & Value for 98 items.
here
a2 = Qty.
b2 = Value
c2 = Qty
d2 = Value

like this continuously 98 items and Last column would be show the Total Qty. & Total Value.
Now I tried manually -
=a2+c2+e2+g2+.........

I believe there is more easy formula, to avoid manual input.

Please Help

Use this in cell GO2 to sum the quantity:

=SUMPRODUCT($A$2:$GN$2,--(MOD(COLUMN($A$2:$GN$2),2)=1))

and this in GP2 for the values:

=SUMPRODUCT($A$2:$GN$2,--(MOD(COLUMN($A$2:$GN$2),2)=0))

Note the only difference is the 1 or 0 at the end (denoting odd or even columns respectively).

Hope this helps.

Pete

Hi Trev,

I see you have used a shorter range than me - I assumed that when the OP said "... 98 items..." he meant there would be 98 * 2 columns worth of data, i.e. 196 columns.

Pete