=SUMPRODUCT(--(ISNUMBER(MATCH(Data!$C$2:$C$1500,{"98366","98367" },0))),--Data!$AB$2:$AB$1500)/--$B$417


Biff

"Max" wrote in message
...
This alternative expression could probably be refined further,
but think we could try:

=SUMPRODUCT((TEXT(Data!$C$2:$C$1500,"00000")="9836 6")+(TEXT(Data!$C$2:$C$150
0,"00000")="98367"), --Data!$AB$2:$AB$1500)/--$B$417
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Scott" wrote in message
...
This is the exact code I am using:
=(SUMPRODUCT(--(DATA!$C$2:$C$1500=98366),
--(DATA!$AB$2:$AB$1500))+SUMPRODUCT(--(DATA!$C$2:$C$1500=98367),
--(DATA!$AB$2:$AB$1500)))/$B$417