Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database Formula Criteria Problem
I am using a DSUM formula to total up accounting entries for numerous
accounts. I use a named range for the database (WTB01) and a named range for the Criteria (UCRS01) and a formula for the SUM column (MONTH(NOW()) +28) as follows =DSUM(WTB01,MONTH(NOW()+28,UCRS01) The criteria range values (in UCRS01) a ACCT 446 446A 446B 446X 446Z 450 450A 450B 450Z The formula works fine for all accounts in the range but it is summing an extra acct it shouldn't named 446BA It seems to be extending the criteria to all values whose first digits match instead of requiring all digits to match. I hope this is clear and thanks for the help. John Donnelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
Database function criteria | Excel Worksheet Functions | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
database criteria | Excel Discussion (Misc queries) | |||
database criteria | Excel Worksheet Functions |