Countif and then some...

[Julie]

hello - I would GREATLY appreciate anyones help here.

I am doing a countif(range, "=AB") however I want to in the next column do
the same countif(range, "=AB") and then countif(newrange, ">07/01/2005)

I'm tryiing to count ab's in one column and then in the second count I need
to say ok out of the ab's I counted in the first formula how many are
>07/01/2005)

Thank you again for anyones tips\formulas!!!! Julie

[Duke Carey]

You'll need to use a sumproduct()

=SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)))


"Julie" wrote:

> hello - I would GREATLY appreciate anyones help here.
>
> I am doing a countif(range, "=AB") however I want to in the next column do
> the same countif(range, "=AB") and then countif(newrange, ">07/01/2005)
>
> I'm tryiing to count ab's in one column and then in the second count I need
> to say ok out of the ab's I counted in the first formula how many are
> >07/01/2005)
>
> Thank you again for anyones tips\formulas!!!! Julie

[Julie]

Hi Duke! Thanks so much for you response...

It was a great help - what if I need to do a date range instead say between
7/1/05 and 7/29/05? how would i put that in the formula?

"Duke Carey" wrote:

> You'll need to use a sumproduct()
>
> =SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)))
>
>
> "Julie" wrote:
>
> > hello - I would GREATLY appreciate anyones help here.
> >
> > I am doing a countif(range, "=AB") however I want to in the next column do
> > the same countif(range, "=AB") and then countif(newrange, ">07/01/2005)
> >
> > I'm tryiing to count ab's in one column and then in the second count I need
> > to say ok out of the ab's I counted in the first formula how many are
> > >07/01/2005)
> >
> > Thank you again for anyones tips\formulas!!!! Julie

[Duke Carey]

Julie -

You can just add one more condition to the formula:

=SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)),--(newrange<DATE(2005,7,29)))


"Julie" wrote:

> Hi Duke! Thanks so much for you response...
>
> It was a great help - what if I need to do a date range instead say between
> 7/1/05 and 7/29/05? how would i put that in the formula?
>
> "Duke Carey" wrote:
>
> > You'll need to use a sumproduct()
> >
> > =SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)))
> >
> >
> > "Julie" wrote:
> >
> > > hello - I would GREATLY appreciate anyones help here.
> > >
> > > I am doing a countif(range, "=AB") however I want to in the next column do
> > > the same countif(range, "=AB") and then countif(newrange, ">07/01/2005)
> > >
> > > I'm tryiing to count ab's in one column and then in the second count I need
> > > to say ok out of the ab's I counted in the first formula how many are
> > > >07/01/2005)
> > >
> > > Thank you again for anyones tips\formulas!!!! Julie

[Julie]

Hi Duke thank you again!

for some reason this isn't calculating for me...
SUMPRODUCT(--(Sheet2!E2:E77="SK"),--(Sheet2!H2:H77>=DATE(2005,7,1)),--(Sheet2!H2:H77<=DATE(2005,7,29)))

it gives me back a 0 where it should be returning 1

"Duke Carey" wrote:

> Julie -
>
> You can just add one more condition to the formula:
>
> =SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)),--(newrange<DATE(2005,7,29)))
>
>
> "Julie" wrote:
>
> > Hi Duke! Thanks so much for you response...
> >
> > It was a great help - what if I need to do a date range instead say between
> > 7/1/05 and 7/29/05? how would i put that in the formula?
> >
> > "Duke Carey" wrote:
> >
> > > You'll need to use a sumproduct()
> > >
> > > =SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)))
> > >
> > >
> > > "Julie" wrote:
> > >
> > > > hello - I would GREATLY appreciate anyones help here.
> > > >
> > > > I am doing a countif(range, "=AB") however I want to in the next column do
> > > > the same countif(range, "=AB") and then countif(newrange, ">07/01/2005)
> > > >
> > > > I'm tryiing to count ab's in one column and then in the second count I need
> > > > to say ok out of the ab's I counted in the first formula how many are
> > > > >07/01/2005)
> > > >
> > > > Thank you again for anyones tips\formulas!!!! Julie