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

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: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

With dates in ColA try the below

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

-- 
Jacob


"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

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.


"Mike H" wrote:

> 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: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

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

On Jan 28, 10:40=A0am, hoyos <ho...@discussions.microsoft.com> wrote:
> I have the following formula
> =3DCOUNTIF(Orders!D:D,"*Stood Down*")
>
> How do I modify it to count text between two dates which are in cells:
> Orders! H3
> Orders! I3

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

"Pete_UK" wrote:

> 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
> 
> On Jan 28, 10:40 am, hoyos <ho...@discussions.microsoft.com> 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
> 
> .
>