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
|