That formula isn't applicable in this case. It is for a range of values
within a single column. This problem involves criteria against two columns.
Countif doesn't work in that situation.
Bob Phillips has posted an Array formula (SumProduct) which does it.
--
Regards,
Tom Ogilvy
"Fredrik Wahlgren" wrote in message
...
wrote in message
oups.com...
OK, I am trying to use countif, but with more that one criteria. Is
this possible.
I have rows that have a format like this:
Letter Amt Date
I need it to count how many rows have a certain letter between certain
dates? Does anybody know how to do this?
I have found an article that mentions countif with more than one criteria
he http://www.mrexcel.com/td0128.html
I don't know how to deal with the dates, though. It must be possible to
get
date as a number, right. In that case, this article will get you started.
/Fredrik