| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with my Excel Database
Hi Marcus
Thanks for the formula, it worked a treat Roopesh "marcus" wrote: Roopesh Regulars will see your question where ever you put it, so if you could restrict your posts to the singular that would be fantastic. The answer to the second part of your question is below. Change the region to reference a cell. Dates A1 = 31-12-1970 and B1 = 1-1-1971 =SUMPRODUCT((A2:$A$18="Sydney")*($B$2:$B$18A1)*($ B$2:$B$18<B1)) Marcus . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
| HELP: VBA Code to extract data from an SQL Server database and put it into Access Database | Excel Programming | |||
| Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
| Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row | Excel Programming | |||
Threaded Mode
