Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
IF / SUMPRODUCT HELP | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
sumproduct | Excel Discussion (Misc queries) | |||
sumproduct | Excel Worksheet Functions |