Glad you got it working fine, Paul. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
<paultedder wrote
Max
you are a champion. I used the following and it works a treat
=SUMPRODUCT(('Grid data'!B9:B4563=A9)*(ISERROR(SEARCH("bob*",'Grid
data'!D9:D4563))*(('Grid data'!F9:F4563="aa")+(TRIM('Grid data'!
F9:F4563)=""))))
Thanks very much Max
Paul