How to count in excel with a variable data as condition

[Elsave]

Hi,

I'm not sure how or where to find answer to the next question

I want to count how many cell are valid to a conditional value.

Let me explain using a table

4	11	240	6
5	7	360	3
3	17	101	4
4	1	300	4
5	3	360	4
4	13	243	3
3	15	135	1

<colgroup><col style="width: 79px"><col width="41"><col width="55"><col width="68"></colgroup><tbody>
</tbody>

I want to know how many cell in the last column have a value 2 less than the value in the first column. Without use of an extra column.

I think something with countif(D:D;....
But what do I use as criteria???

Does anyone know???

Thanks

 

[Snakehips]

Elsave,

Welcome to MrExcel.

Assuming a data range of A1:D1000 (You may edit the rows to suit your max data range)

Perhaps try....

=SUMPRODUCT(--($A$1:$A$1000-$D$1:$D$1000=2))

Hope that helps.