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

You'll need to use a sumproduct()

=SUMPRODUCT(--(range="AB"),--(newrangeDATE(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

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"),--(newrangeDATE(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 -

You can just add one more condition to the formula:

=SUMPRODUCT(--(range="AB"),--(newrangeDATE(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"),--(newrangeDATE(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

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"),--(newrangeDATE(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"),--(newrangeDATE(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