No text. (there are some blanks, some of the B column cells have not
been filled out with a number yet. Those cells contain a formula, but
no value)Would you mind me sending you the document? i have to be doing
something wrong.

Jacob


Vasant Nanavati wrote:
It works for me. Perhaps you have text in some of the cells?

--

Vasant

"jacob" wrote in message
ups.com...
Hi,

I used your formula, but it gives a #VALUE in B5 instead of the
total.
Any ideas?

Technically, I want the formula to add every 15th cell, starting
with
B15 and ending with cell B350. I modified the above formula to end
in
350, but I still get a #VALUE displayed. Any ideas?

Thanks again