COUNTIF: 2 criteria: Date Range Column & Text Column
That did it! Thanks Bob!
"Bob Phillips" wrote:
=SUMPRODUCT(--(C2:C200="text"),--(F2:F200=--"2005-01-01"),--(F2:F200<=--"20
05-01-31"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"MAC" wrote in message
...
Col C = Text and Col F = dates
I would like to count the # of times a value occurs in Col C based on a
date
range in Col F.
Does anybody have an answer to this?
|