Thread: Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Katy Katy is offline
external usenet poster
 
Posts: 23
Default 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