retrieving a sum of matched values in vlookup

[Alan]

Can someone tell what I need to solve this problem?

On sheet1 I have a list of records that have many rows for each subject. Eg.
A B C
Name ACCT AMT
Bill 1101 $ 12.00
Bill 1102 $ 45.00
Bill 1103 $ 22.00
Jeff 1101 $ 10.00
Jeff 1102 $ 80.00
Jeff 1103 $ 17.00


On sheet2 I have a summary page where I need to add together all the individual entries on sheet 1 by person and present it like:
A B
Name Ttl Amt
Bill $ 79.00
Jeff $ 107.00



What command would I need to put in cell B2 on sheet2 to accomplish this?

TIA, Alan

 

[Frank Kabel]

Hi
one way: use SUMIF
in B2 enter
=SUMIF('sheet1'!$A$1:$A$100;"=" & A2;'sheet1'!$C$1:$C$100)
and copy down

You may also consider using pivot tables for this. Have a look at
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm

for some starting information

 

[Alan]

Hi Frank, I copied and pasted in, but I get an error...

Alan

 

[Frank Kabel]

Hi
sorry my fault (wrong translation). Try
=SUMIF('sheet1'!$A$1:$A$100,"=" & A2,'sheet1'!$C$1:$C$100)

 

[brianwa]

How about:
=SUMIF('sheet1'!$A$1:$A$100,A2,'sheet1'!$C$1:$C$100)

Regards
BW

 

[docsboard.com]

Bob, I am sorry to post in the newsgroup, (& my apologies to everyone o
here) I can't seem to get hold of you by email, you had very kindl
helped me with the spreadsheet, did u get my emails?
Please help
Fred: