This is an ideal problem for Pivot Table
See http://peltiertech.com/Excel/Pivots/pivotstart.htm
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address


"Alpha Bravo Charlie" <Alpha Bravo wrote
in message ...
I need to add the values in column "C" If the values in Column "A" are the
same and the values Column "B" are the same. How can I do it ? In the
example
below I want to sum the column "C" if A1=A2 and B1=B2. I have thousands
of
rows so I want to do it in one shot. What should be the formula??? Please
help

A B C
Engineer USA 1000
Engineer USA 100
Engineer USA 300
Doctor Canada 500
Doctor Canada 4000
Doctor China 300
Doctor China 100
Teacher France 200
Teacher Belgium 250