View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vlook fomula vlook fomula is offline
external usenet poster
 
Posts: 43
Default sumproduct _zafar

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


Dear Sir,
the above application could not help me actually my english is not good pry
try to understand me, actually i want to apply formulla and want to get sum
of the add and even column sepectively .
regards