Hi

=SUMPRODUCT((LEFT($B$2:$B$100="J")*($A$2:$A$100=DA TE(2010,3,4)))
--
Regards
Roger Govier

TJ wrote:
What function do i use?

eg.
DATE PAYMENT CODE
01/03/2010 J96
01/03/2010 B24
02/03/2010 C25
04/03/2010 J96
04/03/2010 U96
04/03/2010 J96

im trying to count how many times the letter J in payment code is used in a
specific date.... eg how many J codes was used on 04/03/2010?

Please help.