|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 11th, 2010, 01:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
March 11th, 2010, 01:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#3
March 11th, 2010, 01:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
