Thanks NBVC. Yours works better. I didn't have to manually go into the
formula to make changes on every row that I needed to use the formula on.
Great thanks.
Ayo

"NBVC" wrote:


Have you confirmed it with CTRL+SHIFT+ENTER keys.. to get the { }
brackets..

Also, have you tried my formula.. which is more flexible, in that it
doesn't have to be an "A" at the end.. it accounts for any single
character and it also allows you to change the "spacing" vertically
between values.. right now it is set to 30 for every 30th cell starting
at G8... but you can change that 30 to say 20 if you want to sum every
20th cell, etc...

My formula, too, needs to be confirmed by holding the CTRL and SHIFT
keys and hitting ENTER .


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116324