Formula to capture Specific name and related transaction from another sheet

i am have a Access DB which gives me the updated status of all the pending bills against customers.

i used Links in excel to auto update a sheet in excel the sheets name is bills.

columns as below

Name Amount refrence no.
ABC 100 0001AB
XYZ 1000 0002AB
EDF 100 0003AB
ABC 1000 0004AB
XYZ 100 0005AB

now in another sheet in same excel file i wanna want to put a formula like = sumif ((A1:A1000="ABC") (C1:1000)

the above formula is supposed to put the ABC's 2 bills and summarize them to 1 field....but its not working, i know my fomula is wrong so i googled it and found something called "sumproduct"

i am not sure how to make a formula which use the 2 bills from ABC and put them in 1 field and also add up those 2 amounts to show me a total.

your help is very much appreciated.

regards

Originally Posted by stanleydgromjr

gangooparsad,




If the above data is in Sheet1


Then in the other sheet, try:

=SUMIF(Sheet1!A2:A1000,"ABC",Sheet1!B2:B1000)

Stanley thanks for your reply,

sorry it was my mistake i failed to mention that in the sheet 2

name ABC and the total of 2 amounts of abc is to be mentioned in 2 seperate columns,

i.e.

Column 1 Columns 2
ABC 1100

can you please advice if this is possible.

thanks