Hi all,

Many thanks if you can help me with this.

I have a table of 5 columns and 330 rows of data, in column A, each cell has
one of the numbers from 1 to 8. So for example 4 could be repeated around 40
times.

What I would like to do is add up all the numbers in columns B, C, D & E
dependant on which one of the 8 numbers is in column A. So I would get a
total for all the 1s, a total for all the 2s etc at the bottom of each of
the columns

Hope this makes sense and thank you


Andy