Accumulating cells

[Guest]

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: (e-mail address removed)

Regards

 

[Guest]

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

 

[Guest]

Thanx for your responses. Sorted problem out, am amazed at how quick that was.

Thanx Again.

 

[Guest]

I'm glad that worked for you
(and thanks much for the feedback)


***********
Regards,
Ron

XL2002, WinXP