SQL query in Excel - help !

[facet]

I needed to build a query within an Excel spreadsheet. This query takes
parameters form cells in other spreadsheet.
The problem I faced is that I don't know what value needs to be put into the
cell in order to select all values for given parameter in the examlpe below
this would be "Country" and "Product". I tried many things but none of them
works e.g. "*"

..........WHERE (`Sheet1$`.Country=?) AND (`Sheet1$`.Product=?)

Thanks a milion for someone who know a simple solution.
Cheers

 

[Jim May]

Check out the Sumproduct() function.
This will do the trick.

 

[Bob Phillips]

How have you built the query? Can we see the code?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[facet]

How exactly should I use this function ? Could you get me some example ?
Cheers

 

[Jim May]

Go to:

http://www.dicks-blog.com/archives/2005/07/16/multicolumn-sum-with-wildcard/

for a good review..