"Biff" wrote :
=SUMPRODUCT(--(ISNUMBER(MATCH(Data!$C$2:$C$1500,{"98366","98367" },0))),--Dat
a!$AB$2:$AB$1500)/--$B$417
It's a good refinement, Biff. But going by the same tack that there could
be a mixture of real/text numbers within col C, think a slight adjustment
would be:
=SUMPRODUCT(--(ISNUMBER(MATCH(TEXT(Data!$C$2:$C$1500,"00000"),{" 98366","9836
7"},0))),--Data!$AB$2:$AB$1500)/--$B$417
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--