| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF and text with decimals
Why does Excels SUMIF formula consider cells with text data such as:
2.1 and 2.10 as equal (it sums their values) when used in the range and criteria? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| sumif with text? | Excel Discussion (Misc queries) | |||
| Excel Automatically Changing Decimals to Text as Default | Excel Discussion (Misc queries) | |||
| Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
| Removing leading decimals for text list | Excel Discussion (Misc queries) | |||
Threaded Mode
