| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can conditional sum use wildcards in the formula?
{=SUM(IF(Awhinatia!$A$2:$A$32="Left",IF(Awhinatia! $D$2:$D$32="Registered
Nurse*",Awhinatia!$E$2:$E$32,0),0))} Can conditional sum use wildcards like at the end of nurse in the above formula - If it can have I got the syntax wrong cause it won't accept it unless the test criteria is exact |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
| Using a Formula in a Conditional Statement? | Excel Worksheet Functions | |||
| How to combine conditional format with formula ? | Excel Worksheet Functions | |||
| conditional formatting formula | Excel Discussion (Misc queries) | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
