=countif(c1,g:g)

--
Regards,
Fred


"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:71fcf2b5d616e@uwe...
I have to do a excel sheet that needs a formula that looks at a date in one
column and everytime that date appears in the one column go to another column
and count the amount of times it is there.

example in column c there is todays date. in column g there is info. what
is the simplest way to count what is in column g i the date is in column c.

--
Message posted via http://www.officekb.com