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]

Is that what you want

Book3
	A	B
1	Sales	Count
2	1	0
3	2	0
4	3	0
5	1	2
6	4	0
7	5	0
8	6	0
9	1	5
10
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=COUNTIF($A$1:A2,">"&A2)

 

[Fluff]

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))

 

[Dave Patton]

A concise example would be very useful.
N.B. You can post an extract of your information with the forum's tool XL2BB.

Consider the following:

SumProduct 2020.xlsm
	A	B	C	D	E	F	G
1	18	22	25	30	31	50
2	22	25	20	32	33	65
3	25	15
4	33	40				Increased	5
5	35	40				Decreased	1
6	55	40
7	56	60				Increased	5
8						Decreased	2
9
8b

Cell Formulas
Range	Formula
G4	G4	=SUMPRODUCT(--(A2:F2>A1:F1))
G5	G5	=COUNT(A1:F1)-G4
G7	G7	=SUMPRODUCT(--(B1:B7>A1:A7))
G8	G8	=COUNT(A1:A7)-G7

 

[mottyb]

Below is a list of weekly sales, I want a count of how many weeks sales went up and how many weeks sales went down.
Thanks

 

[Dave Patton]

Try post #3, edit the range for your data.

 

[Sufiyan97]

Is it that?

Book5
	A	B	C	D
1	Week Number	Sales	Went up	Comment
2	1	264,890.25	0	There are 0 Week(s) above where sales was higher than this week
3	2	264,565.21	1	There are 1 Week(s) above where sales was higher than this week
4	3	180,784.51	2	There are 2 Week(s) above where sales was higher than this week
5	4	73,402.25	3	There are 3 Week(s) above where sales was higher than this week
6	5	109,580.24	3	There are 3 Week(s) above where sales was higher than this week
7	6	272,239.00	0	There are 0 Week(s) above where sales was higher than this week
8	7	307,884.26	0	There are 0 Week(s) above where sales was higher than this week
9	8	401,661.80	0	There are 0 Week(s) above where sales was higher than this week
10	9	228,326.28	5	There are 5 Week(s) above where sales was higher than this week
11	10	196,338.96	6	There are 6 Week(s) above where sales was higher than this week
12
13
14
Sheet1

Cell Formulas
Range	Formula
C2:C11	C2	=COUNTIF($B$1:B2,">"&B2)
D2:D11	D2	=CONCATENATE("There are"," ",C2," ","Week(s) above where sales was higher than this week")

-
if not, post some expected results as what you want as result.

 

[mottyb]

Thanks, but still not what I need.
I'm looking for a single count of the total increasing weeks and total of decreasing weeks we have.
Thanks so much

 

[Sufiyan97]

Increasing and decreasing compare to what?

 

[mottyb]

compared to last week's sales

Sample.xlsx
	A	B
1	Week Number	Sales amount
2	1	$ 264,890.25
3	2	$ 264,565.21
4	3	$ 180,784.51
5	4	$ 73,402.25
6	5	$ 109,580.24
7	6	$ 272,239.00
8	7	$ 307,884.26
9	8	$ 401,661.80
10	9	$ 228,326.28
11	10	$ 196,338.96
12	11	$ 364,501.48
13	12	$ 292,169.52
14	13	$ 307,309.22
15	14	$ 238.56
16	15	$ 120,829.28
17	16	$ 119,405.40
18	17	$ 182,721.89
19	18	$ 81,473.25
20	19	$ 356,614.73
21	20	$ 310,232.23
22	21	$ 149,445.19
23	22	$ 82,191.90
24	23	$ 161,630.32
25	24	$ 71,710.67
26	25	$ 197,350.25
27	26	$ 95,565.01
Sheet1