Thanks Teethless mama for your input
There's one thing with your formula , it needs to accumulate
all the entries in column "H" from zero to zero .
G H
-5.0 5.0
-5.0 10.0
-5.0 15.0

22.5 0.0 (because of positive figure in column (G)
-7.0 7.0
-7.0 14.0

-5.0 19.0
-5.0 24.0
-5.0 29.0

-7.0 36.0 ....(sum because of negative figures in
12.0 0.0 column (G) from zerro to zerro)
-7.0 7.0
I apologise for not making my last post very clear

thank you
regards bill
--
bill gras

--
bill gras


"Teethless mama" wrote:

H1 =ABS(MIN(0,G1))
H2 =IF(G2="","",IF(G2<0,SUM(ABS(G2),H1),0))

copy from H2 down as far as needed


"bill gras" wrote:

Hi
I have a column "G" with negative numbers, positive numbers and zero's.
Column "H" is the column that adds up all the negative numbers from
column "G" . When there is a positive number greater than zero i need
column "H" to show a zero from the corresponding cell in column "G"
e.g
G H
-5.0 5.0
-5.0 10.0
-5.0 15.0
22.5 0.0

0.0 0.0
0.0 0.0
-7.0 7.0

42.5 0.0
-7.0 7.0
-8.0 15.0

-6.0 21.0
0.0 0.0
5.5 0.0

-12.5 12.5
-20.0 32.5
-8.0 40.5
There is a empty row between each set of three entrie's
Could any one help me with this please

regards bill





--
bill gras