The formula you posted is missing a closing ) after the last SUM function.

However, the missing ) won't cause what you describe. When adding the
needed ) the formula works correctly.

--
Biff
Microsoft Excel MVP


"Ross" wrote in message
...
Hi Rick-Thanks for responding so quickly. My data actually begins in H10,
so
I updated the formula accordingly. It worked until the figure after the
first input in J. At that point, it started adding the amounts and
inputting
them in J instead of starting over. I'm wondering if I did something
wrong
when I updated the formulas maybe?? Here are the formulas I used in the J
column:
=If(H10=50,H10,"")
=If(SUM($H$10:H11)-SUM($J$10:J10)=50,SUM($H$10:H11)-SUM($J$10:J10,"")

--
smither fan


"Rick Rothstein" wrote:

Since you show your data starting in Row 1, put this formula in J1...

=IF(H1=50,H1,"")

then put this formula in J2 and copy it down...

=IF(SUM($H$1:H2)-SUM($J$1:J1)=50,SUM($H$1:H2)-SUM($J$1:J1),"")

--
Rick (MVP - Excel)


"Ross" wrote in message
...
Hi

I have a ss that I need help with. Col H is a hard input. The formula
for
column J is what I need. The deciding factor is an accumulation of
$50.00
or
more in Col H, at which time it would show that amount in Col J and
start
over from that point until it accumulates another $50 or more. I hope
this
makes sense.
Col H Col J
-.71
4.19
23.55
24.60 51.63
5.00
90.00 95.00

Thanks for your help...
--
smither fan