Countif
 

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

Countif
 

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

Countif
 

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

"Domenic" wrote in message
...
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

Countif
 

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

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

In article ,
"Bob Umlas" wrote:

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

"Domenic" wrote in message
...
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