Hi!
I get error when I try to define a name for a dynamic number of rows why? Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

You have too many parameters. Look in the help index for OFFSET to see your
error.
--
Don Guillett
SalesAid Software

"Calle" wrote in message
...
Hi!
I get error when I try to define a name for a dynamic number of rows why?
Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

Hi,

With :
=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

Make sure :
Your columns to offset is 1 ( and not 0 ), and that it is consistent
with the count number of columns which is equal to 10 ... otherwise
your range cannot be built ...

HTH
Cheers
Carim

Did you spell the worksheet name correctly?

What did you use for the name?

Calle wrote:

Hi!
I get error when I try to define a name for a dynamic number of rows why? Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

--

Dave Peterson

I don't think Excel is liking the way you're using OFFSET(). Try typing that
formula into a cell and you'll get a #Value error. I think, especially in
the case of an OFFSET() that is returning more than a single cell, Excel is
expecting it to be part of another function as:
=SUM(OFFSET(importtotal!$A$1,0,1,COUNTA(importtota l!$A:$A),10))

That's about the best I can do at trying to explain it, maybe someone else
can give a better explanation.

"Calle" wrote:

Hi!
I get error when I try to define a name for a dynamic number of rows why? Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

Ps. I used your formula and created a name Test successfully.



Dave Peterson wrote:

Did you spell the worksheet name correctly?

What did you use for the name?

Calle wrote:

Hi!
I get error when I try to define a name for a dynamic number of rows why? Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

--

Dave Peterson

--

Dave Peterson

Dave Peterson says it should work (worked for him) - I'd trust him on that!
<g I didn't try it as a named formula.

"JLatham" wrote:

I don't think Excel is liking the way you're using OFFSET(). Try typing that
formula into a cell and you'll get a #Value error. I think, especially in
the case of an OFFSET() that is returning more than a single cell, Excel is
expecting it to be part of another function as:
=SUM(OFFSET(importtotal!$A$1,0,1,COUNTA(importtota l!$A:$A),10))

That's about the best I can do at trying to explain it, maybe someone else
can give a better explanation.

"Calle" wrote:

Hi!
I get error when I try to define a name for a dynamic number of rows why? Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

Hi,

Agree with Dave ...
Test OK with me ...
May be the worksheet name ...

Cheers
Carim

I got this formula from
http://www.contextures.com/xlPivot01.html
she seemed to know what she was talking about...

I'm starting to think the swedish excel is bugged somehow...

"Carim" wrote:

Hi,

Agree with Dave ...
Test OK with me ...
May be the worksheet name ...

Cheers
Carim

a re-read suggests I shouldn't have said that....

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...

You have too many parameters. Look in the help index for OFFSET to see
your error.
--
Don Guillett
SalesAid Software

"Calle" wrote in message
...
Hi!
I get error when I try to define a name for a dynamic number of rows why?
Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

I had to change the formula to this:
=OFFSET(importtotal!$A$1;0,1;COUNTA(importtotal!A: A);10)
I guess my version is bugged...

I see that didn't work either. It let me creat a name, but it won't work in a
pivot table

use this formula:
=SUM(OFFSET(importtotal!$A$1,0,1,COUNTA(OFFSET(imp orttotal!$A$1,0,1,9999,1)),10))
but remember it would be dynamic just for 9999 lines and let me know if it
doesn't work

Farhad Hodjat


"JLatham" wrote:

I don't think Excel is liking the way you're using OFFSET(). Try typing that
formula into a cell and you'll get a #Value error. I think, especially in
the case of an OFFSET() that is returning more than a single cell, Excel is
expecting it to be part of another function as:
=SUM(OFFSET(importtotal!$A$1,0,1,COUNTA(importtota l!$A:$A),10))

That's about the best I can do at trying to explain it, maybe someone else
can give a better explanation.

"Calle" wrote:

Hi!
I get error when I try to define a name for a dynamic number of rows why? Is
something wrong with this formula?

=OFFSET(importtotal!$A$1,0,1,COUNTA(importtotal!$A :$A),10)

Hi!
I just found out you have to use ";" instead of "," in the sweish version.
found this formula on the swedish support site:

=FÖRSKJUTNING($B$2;0;0;ANTAL($B$2:$B$200);1)

thx anyway all people... Nice to see everyone come to help :)