sumproduct

Originally Posted by Cutter

With regards to your second request:

Your SUMPRODUCT() isn't specifying >=75%

I would say you have 2 matching entries that are 75% so that the formula as is is totalling them and giving you 1.5.

hello, just wondering wht mean by the following
"I would say you have 2 matching entries that are 75% so that the formula as is is totalling them and giving you 1.5"

also, how can i specify >=75% in this formula?
=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))

basically, column S is where 75% etc are in for, anyone have any suggestions?