| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF and text with decimals
SUMIF (and COUNTIF) does not make a difference between numbers and numbers
represented as text, you would need to use SUMPRODUCT for that =SUMPRODUCT(--(A2:A100="2.10"),B2:B100) will sum B2:B100 where A2:A100 equals "2.10" -- Regards, Peo Sjoblom "Mark" wrote in message ... Why does Excel's 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
