Hello

i ran into somewhat of an issue.

here is my formula
=SUMPRODUCT(--('North America Summary'!$D$9:$D$1852=$C15),--('North America Summary'!$S$9:$S$1852>=$H$7)))

d9:d1852 = city
c15 = city
s9:s1852 = 75%
h7 = 75%

for i.e washington-philadelphia, its showing a total of 8, which is fine. however, when i do a manual filter check, there should only be 6; any ideas why it might pick two extra entries? i filtered by wash-phil (c15), but for some reason its showing 2 extra entries.

also, the formula is being a lil wierd when it comes to adding another criteria:

basically, i would like to search by city, then sales phase (4) and tell me of those how many are >= 75%

i used this formula, but its giving me 1.5 type entries when it should be whole #s

=SUMPRODUCT(--('North America Summary'!$D$9:$D$1852='Regional - Deals, Sales, Other'!$C10),--('North America Summary'!$R$9:$R$1852=$F$7),'North America Summary'!$S$9:$S$1852))

can you pls help, thxs