Brendan,

Problem is that if you just stick that test in, you are checking L3:L9501 to
be equal to value 1 and to value 2, which is not possible. You want an OR
condition

=SUMPRODUCT(--(Inventory!$A$3:$A$9501=0),--(Inventory!$A$3:$A$9501<=7),--(I
nventory!$I$3:$I$9501=$A39),--(Inventory!$J$3:$J$9501=$B39),--(Inventory!$K$
3:$K$9501<"Contested Claim Adj"),--(Inventory!$K$3:$K$9501<"Standard Claim
Adj"),--(Inventory!$K$3:$K$9501<"RX Reimbursements
North"),--(Inventory!$K$3:$K$9501<"Extra Mile
Adj"),--(Inventory!$K$3:$K$9501<"PARIT
Adj"),--(Inventory!$K$3:$K$9501<"Grievance/Appeals
Adj"),--((Inventory!$L$3:$L$9501="Employee Group
502")+(Inventory!$L$3:$L$9501="Emp Grp Member Adj-BlueOptions/BlueCare
549")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Murph" wrote in message
...
I need some help with a complex SUMPRODUCT Formula I have. I'm using 5
different columns in the formula to come up with the data I need. the
first
column is numerical data, and the other 4 are text data. For 3 of the
columns I want to calculate based on multiple values for the same column.
Here is the original formula that was working fine for me.
=SUMPRODUCT(--(Inventory!$A$3:$A$9501=0),--(Inventory!$A$3:$A$9501<=7),
--(Inventory!$I$3:$I$9501=$A39),--(Inventory!$J$3:$J$9501=$B39),
--(Inventory!$K$3:$K$9501<"Contested Claim
Adj"),--(Inventory!$K$3:$K$9501<"Standard Claim
Adj"),--(Inventory!$K$3:$K$9501<"RX Reimbursements
North"),--(Inventory!$K$3:$K$9501<"Extra Mile
Adj"),--(Inventory!$K$3:$K$9501<"PARIT
Adj"),--(Inventory!$K$3:$K$9501<"Grievance/Appeals
Adj"),--(Inventory!$L$3:$L$9501="Employee Group 502"))

Now I have to add one more criteria. I want it to calculate the above
where
column L aslo equals "Emp Grp Member Adj-BlueOptions/BlueCare 549". So at
the end of the formula I added this --(Inventory!$L$3:$L$9501="Emp Grp
Member Adj-BlueOptions/BlueCare 549"). But when I did this formula just
returned a value of '0' . So I'm stuck at how to get it to do this. Any
help would be great.
--
Brendan
--
Brendan