Basically I have a large column of positive and negative numbers. I want to sum the consecutive negative numbers and consecutive positive numbers in the column. I have attached an example.
sumex.xlsx
any help would be greatly appreciated.
thanks!
Bookmarks