One way:

C1: =SUMIF(B:B,D1,A:A)


In article ,
mikeburg
wrote:

I have a list of figures in column A & each figure's 3 digit code in
column B.
What would be a cell formula that could be put in columns C & D to
subtotal by code?

Example

_ ___A__ __B__ __C___ _D_
1| 100.00 | 105 | 211.15 | 105
2| 115.06 | 118 | 315.06 | 118
3| 122.15 | 107 | 272.15 | 107
4| 111.15 | 105 |
5| 200.00 | 118 |
6| 150.00 | 107 |

I am trying to do this without VBA, only formulas or possibly a user
defined function. However, if it can't be done with formulas or a
function then VBA would help a lot!

Thank you for all the help, mikeburg