Thanks everyone.....one more problem. I have dates running from 1/1/2007 to
29/6/2007 from C2 to EB2 and I have attendance as either P or L in the row
14 (C14 to EB14). Now I want to count all the Ps in a month. I want the
formula to look for month 1 in row 2 and then count Ps in row 14.

Also I would need to add the count of both Ls and Ps for some other purpose.

Thanks
Gary

"Gary" wrote in message
...
Hi All,

The formula in cell C32 id =COUNTIF(C14:G14,"P"). This is just the
attendance count for one week. Now in the next column I want next week's
attendance count and when I drag it, the reference moves just one cell
ahead...it becomes =COUNTIF(D14:H14,"P"). I want the refrence to move 5
cells ahead so when I drag it to the next column, it should be
=COUNTIF(H14:L14,"P") and I have 26 weeks.

Please help.
Thanks
Gary