Stating ranges in formulae

  • Thread starter Thread starter Steven Revell
  • Start date Start date
S

Steven Revell

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
 
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,LEN($B10)-
2),CritRange,2,FALSE))

indirect takes the text name of the named range and
returns it as a range.
 
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.
 
Back
Top