TRY:

=SUMPRODUCT(--(Pitches!C15:C67<=Pitches!B5+3),--(D15:D67=<name))

Replace <name with name e.g. "Fred" or cell reference containing name

"simoncottle" wrote:


Thanks

As an add onto this does anyone know how to use countif with multiple
criteria

I have dates of projects that are attached to names, but i want to be
able to count only those projects at today +3 that are attached to
certain names.

At the moment i can count those with deadlines in the next three days
but not attach those to names.

I've tried being clever by separating out another table with the dates
attached to new names, but this isnt working properly and isnt a neat
solution

Thanks Simon


--
simoncottle
------------------------------------------------------------------------
simoncottle's Profile: http://www.excelforum.com/member.php...o&userid=33122
View this thread: http://www.excelforum.com/showthread...hreadid=529744