| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF for texts
Could anyone help me with this?
I want to create a reference on text (like a SUMIF, but for text) input: different persons get "x" on CL01, CL02,... output via formula: OP1,OP2,OP3 listing the column with "x" A B C D H I J 1 CL01 CL02 CL03 OP1 OP2 OP3 2 John x CL01 - - 3 Hugues x x CL02 CL03 - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF or SUMPRODUCT to total cells containing multiple texts | Excel Worksheet Functions | |||
| Concatenation 2 Texts | Excel Discussion (Misc queries) | |||
| sumif function when left 4 texts are matching | Excel Discussion (Misc queries) | |||
| summing texts | Excel Discussion (Misc queries) | |||
| Using Texts in Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
