Not sure exacty what you want, but try this in C1:

=COUNTIF(B$1:B1,B1)

and copy down as required. It will give you a running total of each
value in B, so anything above 1 will indicate repeated values, and the
maximum for any value will indicate how many times that value occurs.

Hope this helps.

Pete

On Feb 5, 1:29*pm, Booman wrote:
I am trying to do a countif function that will show me repeats for 2 days
before and 2 days after through the whole workbook. I am trying to find the
number of repeats through a total of 5 days.

A1 * * * * * * * * * * * B1
1/4/2008 6:26 * 2985
1/4/2008 6:27 * 29855
1/4/2008 6:27 * 2512
1/4/2008 6:28 * 20112
1/4/2008 6:28 * 2985
1/4/2008 6:29 * 2512
1/4/2008 6:29 * 454
1/4/2008 6:30 * 552
1/4/2008 6:30 * 454
1/4/2008 12:25 *29855
1/4/2008 12:26 *135
1/4/2008 12:26 *1485
1/4/2008 12:27 *8859
1/4/2008 12:28 *8021
1/4/2008 12:28 *3132
1/4/2008 12:29 *454
1/4/2008 12:29 *552