Excel 2007 : geting data from duplicate entries

I havew a database with 7 columns and 1000 lines

what I want to do is search the database for duplicate entries in col A and then add up the entries in col F of these duplicates and place the total in h1.

Any one help PLEASE

TA

MaDbrIt

Can you input the value of the specific col A duplicate you seek into cell I1?
Then the formula for cell H1 would be =sumif(a1:a1000,I1,F1:F1000)
If you wanted to easily change the value in cell I1 you could tie it to a data validation list derived from a copy of your col A data with duplicates removed (is that something you are already familiar with?)

Thanks for you reply, I can do what you said, but how will that tie in with your VB program?, I have att a rough form That I will receive from the sales team and a very rough database would set up

The files are test quote sheeet the one i will work from

test database the test database with job numbers already in Col A

Thanks

G

I haven't looked at your samples but just answering your original question. This array formula will sum the values in column F for all associated duplicates found in column A.

=SUM(IF(COUNTIF(A1:A1000,A1:A1000)>1,F1:F1000,0))

entered using Ctrl+Shift+Enter