thank you thank you thank you!!!! That's why I love this site, you learn
something new ALL the time!!!!

"Max" wrote:

whoops, sorry, think I missed the "not" in your specs:
.. get it not to count patients that have SWG or NUR in the HOSP range name

It should be the other way round, viz:
=SUMPRODUCT(('MTD Stats.xls'!FIN=ADMITS!$A15)*('MTD
Stats.xls'!ADMDAY=ADMITS!$B$2)*(ISNA(MATCH('MTD
Stats.xls'!HOSP,{"SWG";"NUR"},0))))

Plug-in criteria: ..*(ISNA(MATCH('MTD Stats.xls'!HOSP,{"SWG";"NUR"},0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---