I'm not sure what the question is if you say the formula works?

Are you asking how to reference an external workbook? If so, here's some
information:
http://ict.cas.psu.edu/training/howt..._maintain.html

Dave
--
Brevity is the soul of wit.


"lee" wrote:

ok.... on my first workbook everything works perfect, however I need to set
up this formula to work for my other 2 woork books....??? this is my formula
so far -
=COUNTIF(O1:O616,AC10)+COUNTIF(P1:P616,AC10)+COUNT IF(Q1:Q616,AC10)+COUNTIF(R1:R616,AC10)+COUNTIF(S1: S616,AC10)

thanks in advance.

Lee.

"Lori" wrote:

If the date is in C1 and the columns are A and B of sheets 1,2 and 3
try:

=INDEX(FREQUENCY(Sheet1:Sheet3!A:B,C1-{1;0}),2)



lee wrote:
please help!!!

how can I set up a formula to count the frequency of a date from several
colums and from 3 work sheets???