| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF, Text, and Leading, 000s
I am having difficulty with using SUMIF over a range of text formatted
numbers. When my criteria is 0001234 it sums the corresponding values associated with 01234, 1234 and 001234. Is there a way to further restrict the summed values for only those item exactly matching 0001234? Thanks for any help you may be able to provide to me. -- Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
| Leading zeroes get dropped when converted to text | Excel Discussion (Misc queries) | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| Remove text leading zero in text string | Excel Worksheet Functions | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
