Countifs One Cell is Greater Than Another in Each Table Row

[andybason]

Hi,

I am trying to write a countifs formula that checks if a cell in one column (called Table[1st]) is greater than a cell in another column (called Table[2nd]) in each row.

This is the formula I'm trying to adapt but I just can't seem to get it to work.

=COUNTIFS(Table[sNo],2, Table[Req],A12, Table

,B12, Table[result],C12)

Can anyone point me in the right direction?

Thanks​

 

[etaf]

how about

=SUMPRODUCT(--(A2:A7>B2:B7))
replace with your table names or use the range

Book2
	A	B	C
1
2	7	5	3
3	2	4
4	3	3
5	4	2
6	5	1
Sheet1

Cell Formulas
Range	Formula
C2	C2	=SUMPRODUCT(--(A2:A69>B2:B69))

 

[andybason]

Thanks etaf!

 

[etaf]

you are welcome