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
|