database functions and criteria

T

TAD from DBL

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")
 
T

T. Valko

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.
 
T

TAD from DBL

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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top