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.

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.