Hi all,

Some times get stuck on basics.. always learning.

iF i FILL IN FORMULA IN sheet2 B2 
=COUNTIF(Sheet1!A2:N20,"a")
AND DRAG IT DOWN THE CELLS CHANGE 
=COUNTIF(Sheet1!A3:N21,"a")
AND SO ON.

Secondly when i drag it down the adjacent cell reference is frozen to "a" where as it should change to b , c,, and so on.

is THERE ANY WAY I CAN DO IT EASILY.

many thanks

Kind regards