| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can we find the stating date of the week in Excel or ms access? | Excel Discussion (Misc queries) | |||
| WEEKNUM calculations for week stating with Tuesday | Excel Worksheet Functions | |||
| Comparing & Stating The Nearest Matching | Excel Discussion (Misc queries) | |||
| My IF statement is stating False but if I manual calculate it it | Excel Discussion (Misc queries) | |||
| Can Named ranges be used in file link formulae? | Excel Worksheet Functions | |||
Threaded Mode
