Another way to do it is to use a Pivot Table.

1. Give your data column headings ('Colour' and 'Count' for example).
2. Click any cell in the data area, go to the Insert tab and click 'Pivot Table' on the left-hand-side. The default option is for the Pivot Table to go on a new worksheet, but you can put it elsewhere on the same sheet if you want.
3. On the right-hand-side, select both 'Colour' and 'Count'.
4. You'll now see a table which has one column headed 'Sum of Count' with the values 7 and 5 shown against Blue and Red. Click either the 7 or 5, then go to 'Summarize Values By' (on the Pivot Table Tools | Options tab). Select 'Product' - the column will now read 'Product of Count' and have the values 12 and 6.

Hope that's of some help too.


Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.