total of different items bought per month

Good morning,

I have a list of different flavoured ice creams per month. I would like to have a total of different flavours I have bought per month.

Is there any way I can create a total from using text (ie ice cream flavours)?

Thanks, yeats48

Take a look at sumproduct

http://www.xldynamic.com/source/xld....UCT.html#dates

VBA Noob