| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula on counting
Try the formula =SUMPRODUCT((B3:B20="John")*(C3:C20= "CXL")) Column B being a list of names and column C being a list of string letters. You can also use named ranges in place of the cell references. JAVB -- JAVB ------------------------------------------------------------------------ JAVB's Profile: http://www.excelforum.com/member.php...o&userid=29304 View this thread: http://www.excelforum.com/showthread...hreadid=498706 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Counting Formula | Excel Discussion (Misc queries) | |||
| formula for counting charachters in a cell ? | Excel Discussion (Misc queries) | |||
| Formula for counting specific cells with value greater than 0 | Excel Discussion (Misc queries) | |||
| Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) | |||
Threaded Mode
