Sum of column

Giganews Newsgroups
Subject: Sum of column
Posted by:  jeanulrich…@gmail.com
Date: Mon, 2 Mar 2009

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

Replies