Hi venkat...
if i have understood your problem, following shud serve the purpose....
Can try "SUMIF" function.
1. In second Sheet if the code is in A1 then type in cell say C1, =sumif(
2. Go to sheet one and select the range from A1 to "end of Column A" (if
column A contains Code) press "F4" to freeze the range
3 put comma
4. go to sheet 2 and select a cell having code say the code is "xyz" and is
in A1, so select A1
5. put comma
6. go to sheet 1 and select the column in which values to be added say
B1:B65000 and press F4 to freeze the range.
7 close brackets and hit enter..
this shud solve your querry
just drag the formula cell in sheet 2 for all codes.
Regards
Satish
On Wed, May 27, 2009 at 11:16 AM, Atul Kesaria <atul.kesa...@gmail.com>wrote:
> Hello Venkat,
>
> Can you provide me with the excel sheet? Or against correponding code in
> second sheet. Apply formula =SUMIF('Sheet1'!(range of your data)'(code name
> cell number)
>
> Thanks and Regards
> Atul Kesaria
>
> On Wed, May 27, 2009 at 9:19 AM, venkat sudhakar <sudhakar...@gmail.com>wrote:
>
>> Dear Friends,
>>
>> I need a formula for my work.
>>
>> There will be 2 Excel sheets.
>>
>> In First Sheet there will be 2 Columns
>>
>> In First column there will be code and in 2nd column there will be value
>> and 'n' number of rows will be there. And the code may be repeated at
>> several times in different rows.
>>
>> And in second sheet also, there will be 2 columns
>>
>> In first column there will be code.
>>
>> Now what i need is, against each item code in second sheet, the sum of
>> values in first sheet representing corresponding code.
>>
>> Can any one do the needful.
>>
>> Regards,
>>
>> Venkat
>>
>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
