what function to use?

[TJ]

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.

 

[Roger Govier]

Hi

=SUMPRODUCT((LEFT($B$2:$B$100="J")*($A$2:$A$100=DATE(2010,3,4)))

 

[Jacob Skaria]

Try

=SUMPRODUCT((A1:A100=DATE(2010,3,4))*(ISNUMBER((SEARCH("J",B1:B100)))))