Another countif question...

[olicowdrey]

I have a range of data for example:

1
1
1
1
2
2
2
3
3
2
2
2
1

and i want to have a total of how many times the number has gone up and how many it has gone down. So in the above example it would be Up=2 and Down =2. The number range is only 1->4

I have tried: =IF(AND(A1="1", A2="2"),"1","") and then would have to nest multiple formulas but i cant even get that to work. Is there a more elegant way?

Thanks as ever

 

[Eric W]

Try:

Excel 2012

	A	B	C	D
1	Data		Increases	Decreases
2	1		2	2
3	1
4	1
5	1
6	2
7	2
8	2
9	3
10	3
11	2
12	2
13	2
14	1

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula C2 =SUMPRODUCT(--(A3:A14>A2:A13)) D2 =SUMPRODUCT(--(A2:A13>A3:A14)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>