| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Case Sensitive SumProduct
I am using this formula:
=(SUMPRODUCT(--($E$48:$E$22962=226);--($J$48:$J$22962=$W19);--($G$48:$G$22962="SailDirectedOrderNotice");$A$48:$ A$22962)) The value in $W19 is 'gd'. in the column of data, there is also 'GD'. The formaul is calculating the 'GD' data, not 'gd'. Is there a way to make the formula case sensitive ? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif function: how to distinguish case/make case sensitive | Excel Worksheet Functions | |||
| make sumproduct lookup case sensitive | Excel Worksheet Functions | |||
| Case Sensitive w/ IF | Excel Worksheet Functions | |||
| .Name case sensitive | Excel Programming | |||
| Case sensitive vlookup | Excel Discussion (Misc queries) | |||
Threaded Mode
