Hi Dave,

sorry....the formula given was for one worksheet in a folder, there are
three worksheets with the same layout in this folder, I need to be able to
use that formula to extract the data from all three worksheets..not just the
one I have the formula in!!

"lee" wrote:

Between both replys I think I have it cracked... Thank you very much.

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