Single statement database/range processing with criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Although Excel provides Database processing (DSUM etc) it does so with
"external" criteria - "external" meaning that they are defined in cells
outside the Database function.

I have seen posts that process ranges with really complex criteria defined
in a single statement. Having all search conditions within the cell statement
is preferable as far as I am concerned as it results in less messy
spreadsheets. Can anyone provide links to articles describing ways to process
ranges/databases with criteria such as the following in a single statement?

Capitalized words represent Fieldnames (column headings).

- find in PRICES_DATABASE the PRICE where ITEM = Search_Item and Search_Date
is >= to PRICE_VALID_FROM and <= to PRICE_VALID_TO

- sum all AMOUNT in TRANSACTIONS_DATABASE where YEAR = 2006 and TRNS_TYPE =
"Sales"

Thanks in advance
 
I am closing this thread since I should have posted it under Worksheet
Functions. Sorry...
 

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

Similar Threads

Single statement database/range processing with criteria 2
SQL with Excel ranges 1
Query Criteria IIf statement 4
database functions and criteria 2
sql stmt issue 1
Dim statement 8
Combine IsNumeric & CountA in single If statement 2
Problem with progamatically defined named ranges 3

Back
Top