Countif to count only increasing cells

[mottyb]

On a long list, I'm trying to count only cells that are higher than the cell above it. (making a formula for every cell (B1>A1) wouldn't work).
On a 'Daily sales' list, I would like to see how many days the sales increased compared to the day before.
Same goes the opposite way, I would like to see how many days the sales decreased compared to the day before.
Your help is greatly appreciated

 

[Sufiyan97]

Have you tried formula in post #3

 

[Fluff]

Have you tried what I suggested in post#3?

 

[mottyb]

Hi & welcome to MrExcel.
Another option

+Fluff 1.xlsm
	A	B
1
2	1	6
3	2
4	3
5	1
6	5
7	6
8	4
9	7
10	7
11	7
12	9
Main

Cell Formulas
Range	Formula
B2	B2	=SUMPRODUCT(--(A3:A100>A2:A99))

Thank you so much

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[mottyb]

Can you please explain what the Hyphens are doing? --

 

[Fluff]

It's called a double unary & it converts True, false values to 1 & 0 respectively.

 

[mottyb]

It's called a double unary & it converts True, false values to 1 & 0 respectively.

Wow, that's valuable knowledge for me.

 

[Fluff]