View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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