Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
database functions and criteria
Is there any way to put criteria right into the function statement instead of
having to place it in a range and just refer to the range? It would be so much easier and flexible if there were some way to stop constructing an outside criteria range everytime I use the database fuctions like dsum, dget, davg etc. Is there a new better way to do this like: =dsum(tablerange, fieldname, criteria right in the function like "firstfield = x") -- Please contact me by email if you have an answer to this question. I appreciate it. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
database functions and criteria
Is there a new better way to do this
Possibly. The SUMPRODUCT function or using array formulas can be used to replace the D functions. However, if you're dealing with a lot of data the D functions are faster. -- Biff Microsoft Excel MVP "TAD from DBL" .(donotspam) wrote in message ... Is there any way to put criteria right into the function statement instead of having to place it in a range and just refer to the range? It would be so much easier and flexible if there were some way to stop constructing an outside criteria range everytime I use the database fuctions like dsum, dget, davg etc. Is there a new better way to do this like: =dsum(tablerange, fieldname, criteria right in the function like "firstfield = x") -- Please contact me by email if you have an answer to this question. I appreciate it. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
database functions and criteria
thanks, I'll look into the array formulas. I am trying to overcome the
seeming necessity of having my source files open when I am updating database functions in another workbook. Why can't the db functions update without the source files being open? Everything is in the same directory. -- Please contact me by email if you have an answer to this question. I appreciate it. "T. Valko" wrote: Is there a new better way to do this Possibly. The SUMPRODUCT function or using array formulas can be used to replace the D functions. However, if you're dealing with a lot of data the D functions are faster. -- Biff Microsoft Excel MVP "TAD from DBL" .(donotspam) wrote in message ... Is there any way to put criteria right into the function statement instead of having to place it in a range and just refer to the range? It would be so much easier and flexible if there were some way to stop constructing an outside criteria range everytime I use the database fuctions like dsum, dget, davg etc. Is there a new better way to do this like: =dsum(tablerange, fieldname, criteria right in the function like "firstfield = x") -- Please contact me by email if you have an answer to this question. I appreciate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non-consecutive criteria database functions | Excel Worksheet Functions | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Database Functions - question using formulas as criteria | Excel Worksheet Functions |