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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
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 |