How do I count crossing zero in a column of integers?

Giganews Newsgroups
Subject: How do I count crossing zero in a column of integers?
Posted by:  Suzie
Date: Tue, 30 May 2006

I have a very long column of data which moves from positive to negative. I
want to count the occasions where it crosses zero, but am having trouble
writing a formula for this condition. Is there a way I can automatically
compare consecutive cells in the column to identify whether it has changed
from negative to positive?

Replies