ExcelBanter - what function to use?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - what function to use? (https://www.excelbanter.com/excel-worksheet-functions/258637-what-function-use.html)

what function to use?

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[_8_]

what function to use?

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.

Jacob Skaria

what function to use?

Try

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

--
Jacob

"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.

All times are GMT +1. The time now is 12:09 AM.