View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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