View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TAD from DBL TAD from DBL is offline
external usenet poster
 
Posts: 9
Default 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.