Problem with Dynamic named range and Offset

[olympiac]

Hi,
I need a cell in worksheet(1) that lists the number of items in the range C4:C50 located in worksheet(Pivot Data Source)

I am using the following formula in 2007 but there must be something wrong because it doesn't work.

=OFFSET(Pivot Data Source!$C$4,4,0,COUNTA(Pivot Data Source!$C4:$C50),1)

ps: in addition, I would like to see only the items and not the empty cells in my list.
Can you assist please?

Thanks

 

[Aladin Akyurek]

We get a FALSE

The sheet is named Pivot Data Source.

Entered in A1:

=OFFSET('Pivot Data Source'!$C$5,0,0,MATCH("*",'Pivot Data Source'!$C:$C,-1)-SUM(ROW('Pivot Data Source'!$C$5))+1)

Applied F9, I get:

{"Dec-10";"Jan-11";"Feb-11";"Mar-11";"Apr-11";"May-11"}