help with database function
 

can someone help me with this:

i have a database named "data", it looks like this:

date covers rev serv food1
10/01/06 100 dining 5000
10/01/06 50 promo 1000

database is located in sheet 2

in sheet 1 i have this:

date food liquor wine
10/01/06 formula here

i want a formula in the food column that looks in "data" for column "food1"
and brings the date=10/01/06 and the rev<"promo", so it will bring 5000

thanks a lot for your help

help with database function
 

A couple of possibilities. One would be to create a pivot table from your
source data. That will allow you to aggregate your data and include or
exclude the itmes you want. The other is to use formulas (as you indicate).
The formula you probalby want is a sumproduct formula. For a complete
explanation check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"andresg1975" wrote:

can someone help me with this:

i have a database named "data", it looks like this:

date covers rev serv food1
10/01/06 100 dining 5000
10/01/06 50 promo 1000

database is located in sheet 2

in sheet 1 i have this:

date food liquor wine
10/01/06 formula here

i want a formula in the food column that looks in "data" for column "food1"
and brings the date=10/01/06 and the rev<"promo", so it will bring 5000

thanks a lot for your help