count variances without variance column?

[gobblechops]

Hi all,

How can I count the variances between 2 columns with a variance greater than 0, without the need for a column with the actual variance?

Currently using =SUMPRODUCT(--($L$61:$L$70>0)) to count the variances greater than zero in column L (column J minus column K) but which formula can I use to do the same thing using the variances between column J & K without the requirement for the calculated variance in column L?

Thanks!

 

[etaf]

how about
=SUMPRODUCT(--(J1:J11-K1:K11>0))

Book1
	F	G	H	I	J	K
1	2
2					1	2
3					2	3
4					6	4
5					6	6
6					6	6
7					7	7
8					7	6
9					7	8
Sheet1

Cell Formulas
Range	Formula
F1	F1	=SUMPRODUCT(--(J1:J11-K1:K11>0))

showing the results in a separate column

do you also need if below zero ?

Book1
	F	G	H	I	J	K	L	M	N
1	2
2					1	2		-1
3					2	3		-1
4					6	4		2
5					6	6		0
6					6	6		0
7					7	7		0
8					7	6		1
9					7	8		-1
Sheet1

Cell Formulas
Range	Formula
F1	F1	=SUMPRODUCT(--(J1:J11-K1:K11>0))
M2:M9	M2	=J2-K2

 

[gobblechops]

Of course, thank you for the solution

 

[etaf]

you are welcome