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