Count cells with specific text between two dates?

[hoyos]

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

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

 

[Mike H]

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)*(ISNUMBER(SEARCH("stood
down",Orders!D))))
--
Mike

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

 

[Jacob Skaria]

With dates in ColA try the below

=SUMPRODUCT((Orders!A1:A100>=Orders!H3)*
(Orders!A1:A100<=Orders!I3)*
(ISNUMBER(SEARCH("stood down",Orders!D1100))))

 

[Mike H]

Hmmm,

I meant to say

In addition, unless you have to use full columns cut back the range from
full columns to something more closely matching your dataset
--
Mike

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

 

[Pete_UK]

COUNTIF only works with one condition. You can use SUMPRODUCT instead
for multiple conditions, though you can't use full-column references
unless you have XL2007 or later. What column do you use for your
dates?

Pete

 

[hoyos]

Thank you all for replying. You all do a great job......fantastic site.
The formula works well. Just the job!
Thank you