Try

=SUMIF(A1:A7,123,C1:C7)

Mike

"b4nature" wrote:

A B C
123 Books 600
123 Supplies 300
123 Misc 200
456 Books 600
456 Fees 800
456 Supplies 300
456 Room 1000

how can I set up a formula so that for like values in column A it would
total column C values that correspond to A...ex. column A value of 123 would
total column C values of 600, 300, 200

Thanks.