Good evening all,

I have a workbook that I have tabs labeled Week 1 through Week 5. I have a
rollup sheet that I am using to count all of the unique values on all of
the sheets.

I am using this Function =COUNTIF('Week 1'!1:44,A2).

Question is When I drag the formula down it changes on each cell as an
example the formula in A3 would be as =COUNTIF('Week 1'!2:45,A3). I have
used the "F4 " key that usually takes care of this but not this time.

What am I overlooking?

Thanks to all,
and a Happy New Year.....

Lomax