hello - I would greatly appreciate anyones suggestions...

I am trying to count ab's in one column and then out of those ab's in one
column how many in the next column over have a date greater than 7/1/05

here is what I started with =countif(range, "=AB")

then I need to add on some how that take that same range and count how many
have the date range greater than 7/1/05

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100DATE(2005,7,1)))

OR

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1))

....where C1 contains your first criterion, such as AB, and D1 contains
your second criterion, such as 7/1/05.

Hope this helps!

In article ,
"Julie" wrote:

hello - I would greatly appreciate anyones suggestions...

I am trying to count ab's in one column and then out of those ab's in one
column how many in the next column over have a date greater than 7/1/05

here is what I started with =countif(range, "=AB")

then I need to add on some how that take that same range and count how many
have the date range greater than 7/1/05

THank you Domenic!

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?


"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100DATE(2005,7,1)))

OR

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1))

....where C1 contains your first criterion, such as AB, and D1 contains
your second criterion, such as 7/1/05.

Hope this helps!

In article ,
"Julie" wrote:

hello - I would greatly appreciate anyones suggestions...

I am trying to count ab's in one column and then out of those ab's in one
column how many in the next column over have a date greater than 7/1/05

here is what I started with =countif(range, "=AB")

then I need to add on some how that take that same range and count how many
have the date range greater than 7/1/05

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100Date(2005,7,1)),--(B1:B100<Date(2
005,7,29)))

If you want your count to be inclusive, change to = and < to <=

Hope this helps!

In article ,
"Julie" wrote:

THank you Domenic!

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?


"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100DATE(2005,7,1)))

OR

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1))

....where C1 contains your first criterion, such as AB, and D1 contains
your second criterion, such as 7/1/05.

Hope this helps!

In article ,
"Julie" wrote:

hello - I would greatly appreciate anyones suggestions...

I am trying to count ab's in one column and then out of those ab's in one
column how many in the next column over have a date greater than 7/1/05

here is what I started with =countif(range, "=AB")

then I need to add on some how that take that same range and count how
many
have the date range greater than 7/1/05

Thanks Domenic - 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

"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100Date(2005,7,1)),--(B1:B100<Date(2
005,7,29)))

If you want your count to be inclusive, change to = and < to <=

Hope this helps!

In article ,
"Julie" wrote:

THank you Domenic!

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?


"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100DATE(2005,7,1)))

OR

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1))

....where C1 contains your first criterion, such as AB, and D1 contains
your second criterion, such as 7/1/05.

Hope this helps!

In article ,
"Julie" wrote:

hello - I would greatly appreciate anyones suggestions...

I am trying to count ab's in one column and then out of those ab's in one
column how many in the next column over have a date greater than 7/1/05

here is what I started with =countif(range, "=AB")

then I need to add on some how that take that same range and count how
many
have the date range greater than 7/1/05

Since Domenic & I are giving you the same answers....

My questions would be:

1) Are the values in column H really date values or text strings that look
like dates?
2) did you get the correct answer with the first formula that had only 2
conditions?
3) are you sure that "SK" represents the entire content of the cell? Either
" SK" or "SK " will return a zero


"Julie" wrote:

Thanks Domenic - 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

"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100Date(2005,7,1)),--(B1:B100<Date(2
005,7,29)))

If you want your count to be inclusive, change to = and < to <=

Hope this helps!

In article ,
"Julie" wrote:

THank you Domenic!

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?


"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100DATE(2005,7,1)))

OR

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1))

....where C1 contains your first criterion, such as AB, and D1 contains
your second criterion, such as 7/1/05.

Hope this helps!

In article ,
"Julie" wrote:

hello - I would greatly appreciate anyones suggestions...

I am trying to count ab's in one column and then out of those ab's in one
column how many in the next column over have a date greater than 7/1/05

here is what I started with =countif(range, "=AB")

then I need to add on some how that take that same range and count how
many
have the date range greater than 7/1/05

Hi Duke and Domenic - thank you both so much!

1.) values in column H are date values 07/01/2005
2.) worked great!
3.) all are "SK"

BUT - I moved my column and forgot to fix it - its working awesome now!!!
Thank you so much!!!


"Duke Carey" wrote:

Since Domenic & I are giving you the same answers....

My questions would be:

1) Are the values in column H really date values or text strings that look
like dates?
2) did you get the correct answer with the first formula that had only 2
conditions?
3) are you sure that "SK" represents the entire content of the cell? Either
" SK" or "SK " will return a zero


"Julie" wrote:

Thanks Domenic - 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

"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100Date(2005,7,1)),--(B1:B100<Date(2
005,7,29)))

If you want your count to be inclusive, change to = and < to <=

Hope this helps!

In article ,
"Julie" wrote:

THank you Domenic!

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?


"Domenic" wrote:

Try...

=SUMPRODUCT(--(A1:A100="AB"),--(B1:B100DATE(2005,7,1)))

OR

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100D1))

....where C1 contains your first criterion, such as AB, and D1 contains
your second criterion, such as 7/1/05.

Hope this helps!

In article ,
"Julie" wrote:

hello - I would greatly appreciate anyones suggestions...

I am trying to count ab's in one column and then out of those ab's in one
column how many in the next column over have a date greater than 7/1/05

here is what I started with =countif(range, "=AB")

then I need to add on some how that take that same range and count how
many
have the date range greater than 7/1/05