hello again gangs,

below is my sample data
A B C
10 0
10 1.00
14 2.00 =(10+14+12+10)=46
12 1.50
10 0.50
16 0
10 0
10 -0.90
8 -1.90
12 -2.00 =(10+8+12+10)=40
10 -1.80
10 0
10 1.00
---------------------------

i need to sum many SEPARATE ranges in column A, if column B <0, and place
the summed range total on column C where the max or min value (other than 0)
on column B is adjacent.
i do not have blank cells ....

really tried this but maybe i can't just do it without this forum...

regards
driller
--
*****
birds of the same feather flock together..