I want to be able to count how many up figure and down figures in a range
Like this example:
In column A: I have the Month numbered 1-12
In column B: I have the days numbered 1-31
In column C: I have the years from 1988-2003
In column D: are the numbers ranging from positive to negative.
I want to be able to for example find:
12th month in (column A) and the fist day (Column B) and count how many Column D numbers are up. And also how many are down.
How can that be done?
Like this example:
In column A: I have the Month numbered 1-12
In column B: I have the days numbered 1-31
In column C: I have the years from 1988-2003
In column D: are the numbers ranging from positive to negative.
I want to be able to for example find:
12th month in (column A) and the fist day (Column B) and count how many Column D numbers are up. And also how many are down.
How can that be done?