Countif on worksheet

[zeek]

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

 

[Frank Kabel]

Hi
do you mean:
=COUNTIF('Week 1'!$1:$44,A2)

or do you want to increment the tab name?. If yes try:
=COUNTIF(INDIRECT("'Week " & ROW(1:1) & "'!1:44"),$A$2)
and drag this down