Stating ranges in formulae
 

Hi,

I was wondering if it possible to state formula in the
following way, i can't figure out how to do it myself but
its along these lines:

DSTDEV(database,field,criteria)

DSTEV(A5:J50,4,array("Code","F0.01"))

I want to specify the criteria myself as opposed to
stating a range. Is it possible or... is possible to state
the formula as:

DSTEV(A5:J50,4,array(A1,C3))

Thanks for any help,

Steven

Stating ranges in formulae
 

criteria requires a range.

--
Regards,
Tom Ogilvy


"Steven Revell" wrote in message
...
Hi,

I was wondering if it possible to state formula in the
following way, i can't figure out how to do it myself but
its along these lines:

DSTDEV(database,field,criteria)

DSTEV(A5:J50,4,array("Code","F0.01"))

I want to specify the criteria myself as opposed to
stating a range. Is it possible or... is possible to state
the formula as:

DSTEV(A5:J50,4,array(A1,C3))

Thanks for any help,

Steven

Stating ranges in formulae
 

I worked around it using a table with named ranges in and
used the lookup to decide which named range to choose.

DAVERAGE($A$7:$J$42,4,INDIRECT(VLOOKUP(LEFT($B10,L EN($B10)-
2),CritRange,2,FALSE))

indirect takes the text name of the named range and
returns it as a range.


-----Original Message-----
criteria requires a range.

--
Regards,
Tom Ogilvy


"Steven Revell" wrote in
message
...
Hi,

I was wondering if it possible to state formula in the
following way, i can't figure out how to do it myself
but
its along these lines:

DSTDEV(database,field,criteria)

DSTEV(A5:J50,4,array("Code","F0.01"))

I want to specify the criteria myself as opposed to
stating a range. Is it possible or... is possible to
state
the formula as:

DSTEV(A5:J50,4,array(A1,C3))

Thanks for any help,

Steven


.

Stating ranges in formulae
 

Not knowing what you are trying to do, you can also use a single criteria
range and have formulas in the criteria cells which "calculate" your
criteria, perhaps based on some input cells.

But glad you found a solution.

--
Regards,
Tom Ogilvy

"Steven Revell" wrote in message
...
I worked around it using a table with named ranges in and
used the lookup to decide which named range to choose.

DAVERAGE($A$7:$J$42,4,INDIRECT(VLOOKUP(LEFT($B10,L EN($B10)-
2),CritRange,2,FALSE))

indirect takes the text name of the named range and
returns it as a range.


-----Original Message-----
criteria requires a range.

--
Regards,
Tom Ogilvy


"Steven Revell" wrote in
message
...
Hi,

I was wondering if it possible to state formula in the
following way, i can't figure out how to do it myself
but
its along these lines:

DSTDEV(database,field,criteria)

DSTEV(A5:J50,4,array("Code","F0.01"))

I want to specify the criteria myself as opposed to
stating a range. Is it possible or... is possible to
state
the formula as:

DSTEV(A5:J50,4,array(A1,C3))

Thanks for any help,

Steven


.