Hi,

You told us where the date criteria are but not where the dates are on the
worksheet so I have assumed ORDERS!C:C

In additiona, unless you have to cut backk the range from full columns to
something more closely matching your dataset

=SUMPRODUCT((Orders!C:C=H3)*(Orders!C:C<=I3)*(ISN UMBER(SEARCH("stood
down",Orders!D:D))))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"hoyos" wrote:

I have the following formula
=COUNTIF(Orders!D:D,"*Stood Down*")

How do I modify it to count text between two dates which are in cells:
Orders! H3
Orders! I3