Hi, I just realized this error seconds before your post. Acutally the I'm
working in row 4. Do I change all of the 1:1' s in the formula to 4:4?
--
phyllis


"Peo Sjoblom" wrote:

Are you entering values in row 1?


--


Regards,


Peo Sjoblom




"phyllis" wrote in message
...
Thanks Bob for your response. However, your formula doesn't appear to be
working. When I enter it, I get a total of 465 no matter what numbers I
input in to the row of cells. I'm not sure what the "IV1" in your formula
represents. I'm trying to add across the row.
phyllis


"Bob Phillips" wrote:

=SUM(IV1:INDEX(1:1,MAX(IF((1:1=0)*(1:1<""),COLUMN (1:1)))))

this is an array formula, so comit with Ctrl-Shift-Enter

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"phyllis" wrote in message
...
I need a formula that will add a string of cells until it finds a cell
with
a
zero, then start the adding again. For example

a b c d e f g h i j k l m n o p q r s t u v
1 8 8 8 0 8 6 5 8 9 0 6 5 4 8 7 6 0 0 5 5 5 5

So the formula would add cells a1 thru v1, but each time it encountered
a
zero, ignore the previous cells and start the calucation from the next
cell.
So the total for row 1 in this example would be 20, which is the total
of
cells s1 thru v1

Any help you can provide is very much appreciated.

thanks
--
phyllis