Hi,

Assuming your worksheet is set up like this. Use the sumif formula

Code Amount
(col A) (Col B)

1 100
2 200
1 300
2 400
3 500
1 600
2 700

1 SUMIF($A$3:$A$9,"1",$B$3:$B$9)
2 SUMIF($A$3:$A$9,"2",$B$3:$B$9)
3 SUMIF($A$3:$A$9,"3",$B$3:$B$9)

Regards,

Ashish Mathur

"Duffey" wrote:

In column B I have numbers 1 thou 10. In column C I have different dollar
amounts I want a total of all the ones a total of all the twos etc in
separate total cells e.g. 1 is the code for all the money spent on fuel this
month. 2 is the code for all the money spent on office supplies etc