Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif / sumif function error
If the criterion for one of these functions is a string of 15+ of numerical
characters only - formatted as text, it will pick up as a match any string of numerical characters only - formatted as text in the same length as the criteria and the first 15 characters match the first 15 characters of the criteria, even though the numerical characters past the 15th character does not match to the criteria, (the reason is probably because these functions are considering a value string €“ formatted as text as a numerical value, and since excel does not keep the actual #s after 15 numerical values it just keeps the 0s so these functions ignore the values after the 15 character because they assume them to be 0s only, they just check the length to be the same after the 15th character.) Example: A1: '1234567890123456 A2: '1234567890123457 B1: =Countif(A1:A2,A1) the result is 2 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function Countif that operates like Sumif? | Excel Worksheet Functions | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
Lookup Function Error | Excel Worksheet Functions |