Try...

=SUMPRODUCT(--(A13:A68="US-Northeast"),--(ISNUMBER(MATCH(I13:I68,{"OCT","
NOV","DEC"},0))),--(K13:K68="02 - Qualified"),F13:F68*0.25)

Hope this helps!

In article ,
"FrankTimJr" wrote:

I'd like to calcluate a range based on 3 different conditions:

Area="Northeast"
Closed Month="OCT","NOV","DEC"
Sales Stage="02 - Qualified"
Range to calculate: Total Sales (times 25%)

The formula I used is this:

=SUMPRODUCT((A13:A68="US-Northeast")*(I13:I68,{"OCT","NOV","DEC"})*(K13:K68 ="0
2 - Qualified")*((F13:F68)*.25))

Yet it's giving me an error. The thing that is raising my eyebrow on it is,
when the formula is getting written, you can see the ranges selected in the
color-coded boxes, but only two ranges seem to be selected: "Area" and "Close
Month". "Sales Stage" and "Total Revenue" are not selected for some reason.

Any ideas?