"daddylonglegs"
Try this amendment

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


OK this does return a value thank you
Is this result column E * W row by row or does this formula total E then *
by W which obviously is an incorrect result?

also, my Qty and Cost data is recorded in '000s and I'd like to /100 if at
all possible

Thanks in advance
--
Vass