Enter the date you want to count in a helper cell, say A1.

=COUNTIF(O1:O18,A1)+COUNTIF(P1:P18,A1)+COUNTIF(Q1: Q18,A1)

Dave
--
Brevity is the soul of wit.


"lee" wrote:

I have looked at this but can not get my head aruond it!!!

I have an array of dates from "O1 to O18" & "P1 to P18" & "Q1 to Q18"

This is then complicated by having 3 worksheets with this data on and I need
to know how many times a particular date occours within all these ranges!!

Can you help Dave??


"Dave F" wrote:

Look at the COUNTIF function.

Dave
--
Brevity is the soul of wit.


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