=sumiif?

[MarcJohn]

I have a set of data that goes back a few years and updates daily, causing the date and data to push down one row everyday. I am trying to track how many days in a row the data is higher or lower. I used a IF formula with a binary 1,0 outcome to track if the data is higher or lower than the day before (Column C below). Now I need to figure out how to track how many consecutive days the data moves up or down, as the data moves through time (Column D below). I think I need to use =Count(SUMIF()) in some way but am not sure. For instance, in the below example the answer would obviously be 2, for the last two days when the yield went up... but how do I keep track of this when everyday the data is automatically pushed down one row and new data is added? Any ideas?

Date	Yield	IF(B2>B3,1,0)	???
=Now	0.390785	1
6/2/14	0.389	1
5/30/14	0.375	0
5/29/14	0.377	1
5/28/14	0.367	1
5/27/14	0.346	1
5/26/14	0.344	0
5/25/14	0.345	....
.... and so on....	....	.....

<tbody>
</tbody>

Thanks in advance!

 

[Scott Huish]

Unless you actually need them to be 1's and 0's. You can use TRUE/FALSE instead, and then your formula in
C2
=B2>B3

Copy down
Formula in D2:
=MATCH(FALSE,C:C,0)-2

Excel Workbook
	A	B	C	D
1	Date	Yield
2	6/3/2014	0.390785	TRUE	2
3	6/2/2014	0.389	TRUE
4	5/30/2014	0.375	FALSE
5	5/29/2014	0.377	TRUE
6	5/28/2014	0.367	TRUE
7	5/27/2014	0.346	TRUE
8	5/26/2014	0.344	TRUE
Sheet1

 

[MarcJohn]

Awesome, Thanks!

What is the -2 for at the end?

 

[Scott Huish]

It's just subtracting for the row your data starts on.

 

[MarcJohn]

SO this tracks up days but gives me 0's when there are down days. Would I just change it to B2<B3 for your above example if I want to track down days?