Thread: SUMIF and text with decimals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
  
Posts: 989
Default 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?

Reply With QuoteReply With Quote