SUMIF with a list of unkown criteria

[londbrit]

I need to write some code to look through a list and sum all the values of the same names i.e.

Item a
Item b
Item c
Item b
item d
Item a
Item a


Total value for all item a =
Total value for all Item b =
etc.

Is there an easy way to do this. I started by creating many variables but this makes the code very long and slow.

Any help would be appreciated.

[TMS]

Try using a Pivot Table

Regards

[londbrit]

Thanks The format may be not what I was looking for but it will do thanks.

[TMS]

Depends how much effort you want to put into it.

You could, for example, use an Advanced Filter to extract unique item references and then use SUMIF to calculate the totals. Clearly, you could do what you want with the formatting.

Regards