M
MLP
I"m using Excel 2000. The issue I'm having is regarding using defined Names
and the SUMIF function. When I set up the SUMIF formula to refer to a
particular defined range (NAME) and look for the criteria I've selected (in
my case a particular city), the result I get is a summation of more than just
the particular criteria (city). The formula is set as follows:
=SUMIF(Property, $A7,'Final'!$Y$2:$Y$1021)
Where Property is the Named range to review, $A7 is the particular city to
match, and the 'Final...' is data to sum if the city names match. In my case
the sum is including more than one city, even though only one city is
selected.
Any thought on why my formula is including more than cities than selected?
and the SUMIF function. When I set up the SUMIF formula to refer to a
particular defined range (NAME) and look for the criteria I've selected (in
my case a particular city), the result I get is a summation of more than just
the particular criteria (city). The formula is set as follows:
=SUMIF(Property, $A7,'Final'!$Y$2:$Y$1021)
Where Property is the Named range to review, $A7 is the particular city to
match, and the 'Final...' is data to sum if the city names match. In my case
the sum is including more than one city, even though only one city is
selected.
Any thought on why my formula is including more than cities than selected?