Read it as a test

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


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Vass" wrote in message
...


"Bob Phillips" wrote

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

returns #VALUE!

I can see what your doing but can't fix it
--
Vass