What if I want to leave dan and pete in the same column and I basicaly want
to set up a report like this on another worksheet

Dan 1
Pete 1

Assuming that there was only one date that was less than the 1-3-07

"Pete_UK" wrote:

Your requirement wasn't that clear in your first posting. Put Dan in
D1 and Pete in D2 and put this formula in E1:

=SUMPRODUCT((B$1:B$100<=DATE(2008,7,31)*(A$1:A$100 =D1))

Copy it into D2 (or further down if you have other names in column D).

Hope this helps.

Pete

On Nov 16, 7:46 pm, Dan Soleau
wrote:
That didn't work. what i have is a tracker setup like this

Dan 1-1-07
Dan 1-3-07
Pete 1-3-07
Pete 1-3-07
Pete 1-1-07

I want to know, how many dates are there less than 1-3-07 for Dan and then
also for pete. So I will have to use a formula that has both columns
involved.



"Pete_UK" wrote:
Try this:

=SUMPRODUCT((B1:B100<=DATE(2008,7,31))

I've assumed your dates are in B1:B100 - adjust to suit.

Hope this helps.

Pete

On Nov 16, 7:18 pm, Dan Soleau <Dan
wrote:
I have two columns. One contains general contractor names the other contains
dates from current until december of 2008. I want to create an updating
formula to count how many dates are less than or equal too 7/31/08 for each
contractor.- Hide quoted text -

- Show quoted text -