Count cells with specific text between two dates?

  • Thread starter Thread starter hoyos
  • Start date Start date
H

hoyos

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.
 
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))))
 
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.
 
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
 
Thank you all for replying. You all do a great job......fantastic site.
The formula works well. Just the job!
Thank you
 
Back
Top