Say in D1 to D10 you enter the numbers 1 to 10.
Then in E1, enter this formula:
=SUMIF(B:B,D1,C:C)
And copy down to E10.
Column E shows the total of each number in Column D.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Duffey" wrote in message
...
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
|