Countif

[Katy]

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

 

[Domenic]

Try...

=SUMPRODUCT(--(D25>=C2:C5*2))

 

[Bob Umlas]

I think he means:
=SUMPRODUCT(--(D25>=C2:C5+2))
("+", not "*")

 

[Domenic]

Mis-read... Thanks for catching it, much appreciated!