=SUMPRODUCT(--(data!DA2:DA7199="RETAILAC"),--(data!E2:E7199,data!W2:W7199))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Vass" wrote in message
. uk...
OK I've tried this

data! being the second sheet holding the data
the first array is a condition that I only want customers = "RETAILAC" to
be
included
data!E = quantity
data!W=cost price

=SUMPRODUCT(data!DA2:DA7199="RETAILAC",data!E2:E71 99,data!W2:W7199)

but this returns a 0 value
any clues?
thanks
--
Vass