| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any body out there smart enough???
Another way: =SUMPRODUCT(('detail sheet'!$A$1:$A$10=331)*('detail sheet'!$B$1:$B$10<"")) HTH Jean-Guy -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=512827 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Smart Tags and Stock Symbols | Excel Worksheet Functions | |||
| smart tags and stock updates | Excel Discussion (Misc queries) | |||
| Person Names Smart Tag problems | Excel Discussion (Misc queries) | |||
| smart tags | Excel Discussion (Misc queries) | |||
| Adding Smart Tags to an unrecognized cell reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
