sumproduct_zafar

[vlook fomula]

I have two diff things in two diff column and rage of columns are 30 I always
calculate manually by using +. Kindly advise me any easy formula and mention
the site of temples to look the flow of application

Examples
Total
Description Pack Kgs Pack kg Pack Kg

A123 2 400 1 200 ? ?
B123 1 200 3 600 ? ?
C123 5 1000 2 400 ? ?
D123 1 200 2 400 ? ?


Regards

 

[Pete_UK]

Assuming your headings are in row 1 and your data occupies A2:E31, put
this formula in F2:

=B2+D2

and this one in G2:

=B2*C2 + D2*E2

Copy these down the column - an easy way is to select F2 and double-
click the fill handle (the small black square in the bottom right
corner of the cursor). Then select G2 and do the same.

Hope this helps.

Pete