| Home |
| Search |
| Today's Posts |
|
#1
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
