Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accumulating cells
Hi my namie is Ryan, am in urgent need of help.
Here is an example of what i need to do, have no clue how to it tho. Pls help. Iv got a Exel workbook with 2 sheets. On sheet1 there is, lets say 3 colums. Col1 is DATE, Col2 is NAME, Col3 is AMOUNT. User enters info whole month, so there is many rows, lots with same NAME. On sheet2 there is 2 columns. Col1 NAME,Col2 is AMOUNT. What i need to do is, evertime a user enters a row, Exel must find the row with same matching NAME in sheet2, and add the amount from sheet1 to sheet2 automaticly. Basicly sheet2 has all name and an uptodate AMOUNT for each NAME. Tried all sort of formulas but i dont have the Exel ability to do this. Please any1 email me with a solution at: Regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accumulating cells
If the DATE, NAME, AMOUNT fields are on Sheet1 in columns A through C
Try something like this on Sheet2: A2: (a name) This formula returns the sum of all amounts in Sheet1, Col_C, where the Col_B value matches the name in Sheet2 cell A2 B2: =SUMIF(Sheet1!B:B,A2,Sheet1!C:C) Does that help? *********** Regards, Ron XL2002, WinXP "RR Dunn" wrote: Hi my namie is Ryan, am in urgent need of help. Here is an example of what i need to do, have no clue how to it tho. Pls help. Iv got a Exel workbook with 2 sheets. On sheet1 there is, lets say 3 colums. Col1 is DATE, Col2 is NAME, Col3 is AMOUNT. User enters info whole month, so there is many rows, lots with same NAME. On sheet2 there is 2 columns. Col1 NAME,Col2 is AMOUNT. What i need to do is, evertime a user enters a row, Exel must find the row with same matching NAME in sheet2, and add the amount from sheet1 to sheet2 automaticly. Basicly sheet2 has all name and an uptodate AMOUNT for each NAME. Tried all sort of formulas but i dont have the Exel ability to do this. Please any1 email me with a solution at: Regards |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accumulating cells
Thanx for your responses. Sorted problem out, am amazed at how quick that was. Thanx Again. "Ron Coderre" wrote: If the DATE, NAME, AMOUNT fields are on Sheet1 in columns A through C Try something like this on Sheet2: A2: (a name) This formula returns the sum of all amounts in Sheet1, Col_C, where the Col_B value matches the name in Sheet2 cell A2 B2: =SUMIF(Sheet1!B:B,A2,Sheet1!C:C) Does that help? *********** Regards, Ron XL2002, WinXP "RR Dunn" wrote: Hi my namie is Ryan, am in urgent need of help. Here is an example of what i need to do, have no clue how to it tho. Pls help. Iv got a Exel workbook with 2 sheets. On sheet1 there is, lets say 3 colums. Col1 is DATE, Col2 is NAME, Col3 is AMOUNT. User enters info whole month, so there is many rows, lots with same NAME. On sheet2 there is 2 columns. Col1 NAME,Col2 is AMOUNT. What i need to do is, evertime a user enters a row, Exel must find the row with same matching NAME in sheet2, and add the amount from sheet1 to sheet2 automaticly. Basicly sheet2 has all name and an uptodate AMOUNT for each NAME. Tried all sort of formulas but i dont have the Exel ability to do this. Please any1 email me with a solution at: Regards |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accumulating cells
I'm glad that worked for you
(and thanks much for the feedback) *********** Regards, Ron XL2002, WinXP "RR Dunn" wrote: Thanx for your responses. Sorted problem out, am amazed at how quick that was. Thanx Again. "Ron Coderre" wrote: If the DATE, NAME, AMOUNT fields are on Sheet1 in columns A through C Try something like this on Sheet2: A2: (a name) This formula returns the sum of all amounts in Sheet1, Col_C, where the Col_B value matches the name in Sheet2 cell A2 B2: =SUMIF(Sheet1!B:B,A2,Sheet1!C:C) Does that help? *********** Regards, Ron XL2002, WinXP "RR Dunn" wrote: Hi my namie is Ryan, am in urgent need of help. Here is an example of what i need to do, have no clue how to it tho. Pls help. Iv got a Exel workbook with 2 sheets. On sheet1 there is, lets say 3 colums. Col1 is DATE, Col2 is NAME, Col3 is AMOUNT. User enters info whole month, so there is many rows, lots with same NAME. On sheet2 there is 2 columns. Col1 NAME,Col2 is AMOUNT. What i need to do is, evertime a user enters a row, Exel must find the row with same matching NAME in sheet2, and add the amount from sheet1 to sheet2 automaticly. Basicly sheet2 has all name and an uptodate AMOUNT for each NAME. Tried all sort of formulas but i dont have the Exel ability to do this. Please any1 email me with a solution at: Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accumulating elapsed times. | Excel Discussion (Misc queries) | |||
accumulating values generated daily | Excel Worksheet Functions | |||
accumulating total | Excel Discussion (Misc queries) | |||
need help with compounding and accumulating formula... | Excel Discussion (Misc queries) | |||
Accumulating Values in a Pivot table | Excel Discussion (Misc queries) |