Sum of column

  • Thread starter Thread starter jeanulrich00
  • Start date Start date
J

jeanulrich00

Hi

I have a worksheet containing 25 columns

In the column A I have categories and the other columns B to Z
represent periods

Looks like this

PLB 1 2 3 1 2 2 2 3 ..................
ADD 3 4 2 4 1 5 6 4 ..................
AVL 2 1 4 2 3 7 1 4 ...................
PLB 2 3 2 1 5 2 4 3 .....................

I am looking for a formula that will add each columns for the same
Categorie

So the result for the categorie PLB should be 1+2+3+1+2+2+2+3 (first
row) + 2+3+2+1+5+2+4+3 (last row) = total = 38

ADD = 29
AVL = 24

thanks for helping
 
Back
Top