Thanks Max. Really appreciate it
"Max" wrote:
"Evan" wrote:
Max -- Thanks so much. This works except if there's a blank cell in the
range it won't ignore it. How can I tweak it?
Try, array-entered (CSE) as befo
=AVERAGE(IF((ISNUMBER(MATCH(A1:A5,{"John";"Jane"}, 0)))*(B1:B5<""),B1:B5))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---