Try...

=SUMPRODUCT(--(D2:D5=C2:C5*2))

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
Katy wrote:

Hello all, could someone please help... I work in a school and am trying to
create a tracking grid to map pupil progress.

I need to count the number of times the value in a cell in one column is at
least 2 more than a value in another colume e.g. where a cell in column D
holds a value greater than the corresponding cell in column C by at least
2....

C D
1 3
2 4
2 3
1 5

would give a value of 3

Can I use countif to do this??
Thanks