Yeah, I know. I didn't realize it until I saw your post.
Jason
-----Original Message-----
Hi Jason
just a picky one :-)
no need for a double minus in this case :-)))
--
Regards
Frank Kabel
Frankfurt, Germany
Jason Morin wrote:
One way:
=SUMPRODUCT(--(70-CODE(A1:A5)))
HTH
Jason
Atlanta, GA
-----Original Message-----
Help please.
Advice on how to add a row of cells (e.g. a1 - a5) as
a
corporate sum (shown in A6) where each cell is shown
in
the cell by a letter of the alphabet representing a
sum
figure.
i.e
A + B + C + D + E = 15
(where a=5; b=4; c=3; d=2 and e=1)
Thanking you.
.
.
|