A couple of things... I column Q actual dates that have been formatted mm/yy
or is it text. If it is text then your criteria needs to be in the same
format and not "Apr-08". Secondly try using the unary operator -- to coerce
the true/false values to 1/0 values.

=SUMPRODUCT(--(Data!B1:B20000="ABC
Company"), --(Data!Q1:Q20000="Apr-08"), (L1:L20000))

if Q is actual dates then

=SUMPRODUCT(--(Data!B1:B20000="ABC
Company"), --(Month(Data!Q1:Q20000)=4), --(Year(Data!Q1:Q20000)=2008),
(L1:L20000))
--
HTH...

Jim Thomlinson


"MadWoman" wrote:

The formula returns a 0. I need it to return $38,241.51

=SUMPRODUCT((Data!B1:B20000="ABC
Company")*(Data!Q1:Q20000="Apr-08")*(L1:L20000))The formula below returns a
0. I need it to return $38,241.51.

Column B = Company Name
Column Q = MM/YY
Column L = Subtotal dollar amount

What am I missing and how can this be corrected to return the correct value.