sumproduct_zafar
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
On Jul 23, 9:46*am, vlook fomula
wrote:
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
|