| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and count (sumproduct)
I am trying to find OP in the list of cells. It works if it is the only
words in the cell but I need it to work if there is more than just "OP". Suggestions? =SUMPRODUCT(--(MID('Jan-'!H2:H65536,1,6)="OP"),+('Jan-'!C2:C65536)) -- Thank you for your time. Windows XP Office 2002 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT, count & sum | Excel Worksheet Functions | |||
| count if or sumproduct? | Excel Discussion (Misc queries) | |||
| Count without SUMPRODUCT | Excel Worksheet Functions | |||
| Count if and Sumproduct | Excel Discussion (Misc queries) | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
Threaded Mode
