error using this simple formula
 

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)

error using this simple formula
 

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)

error using this simple formula
 

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

error using this simple formula
 

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

error using this simple formula
 

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)

error using this simple formula
 

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

error using this simple formula
 

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)

error using this simple formula
 

Hi,

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

Cheers
Carim

error using this simple formula
 

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

error using this simple formula
 

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

error using this simple formula
 

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)

error using this simple formula
 

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...

error using this simple formula
 

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

error using this simple formula
 

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)

error using this simple formula
 

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 :)