=SUMPRODUCT(--(ISNUMBER(M
ATCH(Table!A1:A15,E1:A10000,0))),--(L1:L10000120))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Allan from Melbourne" wrote
in message ...
Hello
Hopefully some kind person can assist with this.
I have a worksheet with n number of rows (can vary from 30 to 3000) and
columns from a to m (13). I need to count the number of times that column
L
value exceeds 120 when column E = a pre defined value. This pre defined
value
can equal 320, 744, 743, 73H and many more.
I have a table set up that has these required "pre defined values". Keep
in
mind that this table is dynamic, values can be added or deleted. The
reference for this table is on another worksheet "table" A1..A15. I don't
mind where this table is located, it just happens to be in this seperate
worksheet.
I can sort or filter however I was wondering if there was a better way to
count the occurrences.
Many thanks
Regards
Allan