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
|