Hi,

dates in Excel are numbers formatted to be seen as dates we recognise so
provided you have no numbers other than dates in Column C this should work

=SUMPRODUCT((ISNUMBER(C1:C30)*(H1:H30="Joe Bloggs")))

If you do have numbers that aren't dates in c then post back.

Mike

"Joel D" wrote:

Hi there,

Let me see if I can make this question make sense. I have two colums in
excel, C and H. Column 'C' contains some cells that have a date (in the form
of mm/dd/yyyy). Column 'H' contains names. I am trying to count the number
of times a name occurs, IF there is a date in column c. (No date specificly).

Thanks for your help

Joel