You can't reference the whole column if you use Excel up to and included
2003, you would need to use

A5:A65535


having said that, do you really have that many rows? If you do formula like
that might slow down the workbook quite a bit

--


Regards,


Peo Sjoblom

"Tommy" wrote in message
...
Hi,

I see that it is an old post, however I am in a similar situation. The
formula you provided below doesn't reference the entire column. I am
referencing data from another worksheet in an entire column. Can you
help?

Tommy

"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?