Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM Criteria - find exact match only
Hello -
I am working in Excel 2007 and am having trouble limiting the values for the criteria to an exact match only. The function is summing all criteria that begin with the named range, ie account1110POL* I have set up a google doc at http://spreadsheets.google.com/ccc?k...YkCCcaWQ&hl=en with details to clarify. Formula: =DSUM(Prior_Year_Budget_Data,"Prior Year Budget",account1110POL) Named ranges: The named range I am looking for is "account1110POL" which corresponds to the following 2 lines: Business unit business object 71205001110POL However, it is also summing values for the following named ranges: Range name = 71205001110POLMGM Business unit business object 71205001110POLMGM Range name = 71205001110POLSRO Business unit business object 71205001110POLSRO Your help greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM Criteria - find exact match only
Try
Instead of 71205001110POL in the second row of the criteria range use ="=71205001110POL" It will look like this after pressing enter =71205001110POL but it need 2 equal sign plus teh quotations That way it will only sum the exact match -- Regards, Peo Sjoblom "Sandy" wrote in message ... Hello - I am working in Excel 2007 and am having trouble limiting the values for the criteria to an exact match only. The function is summing all criteria that begin with the named range, ie account1110POL* I have set up a google doc at http://spreadsheets.google.com/ccc?k...YkCCcaWQ&hl=en with details to clarify. Formula: =DSUM(Prior_Year_Budget_Data,"Prior Year Budget",account1110POL) Named ranges: The named range I am looking for is "account1110POL" which corresponds to the following 2 lines: Business unit business object 71205001110POL However, it is also summing values for the following named ranges: Range name = 71205001110POLMGM Business unit business object 71205001110POLMGM Range name = 71205001110POLSRO Business unit business object 71205001110POLSRO Your help greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find exact match, same workbook, different sheets | Excel Discussion (Misc queries) | |||
Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
using vlookup to find exact match | Excel Discussion (Misc queries) | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |