| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
One way:
X1: =(D1="*")+(I1="*") Y1: =2-X1 Select X1 and Y1 and copy down as far as necessary. In article , "anat" wrote: Yes, I want to count the number of asterisks in each row (of columns D & I) and put the result in column X of that row. And if it has no asterisks count the blanks and put the results in Col Y since the asterisks represents a type of an employee. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 If Statements between 2 values Q | Excel Worksheet Functions | |||
| 4 different if statements, not working | Excel Worksheet Functions | |||
| Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Threaded Mode
