I am trying to use SUMPRODUCT for summing instances where cells contain part
of the word €œUltra€� for the period 1/06/2009 to 30/06/2009 (dd,mm,yyyy
format).

=SUMPRODUCT(--(I63:I222=--"1-06-2009"),--(I63:I222<=--"30-06-2009")) works
ok
=SUMPRODUCT(ISNUMBER(SEARCH("Ultra",F63:F220))*Q63 :Q220)
Works ok

But when combined
=SUMPRODUCT(--(I63:I222=--"1-06-2009"),--(I63:I222<=--"30-06-2009"),(ISNUMBER(SEARCH("Ultra",F63:F220))*Q63:Q22 0))
gives a #value! error.

Where have I gone wrong?

--
Fergus