View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Need formula help

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