| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct with both number and text formats
I currently use the following formula
=SUMPRODUCT(($J$5:$J$4000=$T$4007)*($AS$5:$AS$4000 <0)*($AS$5:$AS$4000)) But it does not seems to work if the value in column J is formated as text ( ex 3644 or '3644) Is there a way to modify the formula so that it does not matter if the value in column J is foramted as a number or text? Thanks ce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with either text of number format | Excel Worksheet Functions | |||
| Custom number formats in TEXT function | Excel Worksheet Functions | |||
| Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
| Sumproduct with different number formats | Excel Discussion (Misc queries) | |||
| Can you retain different text formats when merging text? | Excel Discussion (Misc queries) | |||
Threaded Mode
