Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database function - convert flat table | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |