Prev: Problem with Calculated item in Pivot Table
Next: How do I collapse a menu in Excel
From: hoyos on 28 Jan 2010 07:12
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...(a)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
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Problem with Calculated item in Pivot Table
Next: How do I collapse a menu in Excel