what function to use?
in [Functions]
|
Prev: Why does my text in a cell with wrap text and auto height get cut
Next: Multiply Cell Values which include text units
From: TJ on 11 Mar 2010 08:04 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.
From: Roger Govier on 11 Mar 2010 08:15 Hi =SUMPRODUCT((LEFT($B$2:$B$100="J")*($A$2:$A$100=DATE(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. >
From: Jacob Skaria on 11 Mar 2010 08:35
Try =SUMPRODUCT((A1:A100=DATE(2010,3,4))*(ISNUMBER((SEARCH("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. > |