the colums are numbered same as rows
how do I change them to letters?
--
fergie


"Steved" wrote:

Hello From Steved

below starts at A4:G15 Column A is place, Colum B is Product I need to sum
D4:D15
I need a total for product P how do I do this Please

A B C D E
F G
1 P 5982 5982 5982 5982
1 P 13154 13154 13154 13155
1 S 258 258 258 258
1 P 13154 13154 13154 13155
1 S 258 258 258 258
1 P 13154 13154 13154 13155
1 S 272 272 272 272
1 P 13154 13154 13154 13155
1 S 258 258 258 258
1 P 13204 13204 13204 13204
1 S 258 258 258 258
1 P 7767 7767 7767 7767

Thankyou.