| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't recognize data
I am using the following formulas to count the occurrence of units:
=SUM(($F$555:$F$1085="")*($D$555:$D$1085="5A")). This formula will recognize all units except 3A. Then it returns 0, which I know is incorrect. In a separate formula: =(COUNTIF($K$555:$K$1085,"5A")), where K555 is showing "=D555", this formula will also not recognize 3A but will recognize everything else. Both column D and K are formatted as General. Has anyone heard of this kind of a problem? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula won't recognize data
Are you absolutely certain that "3A" in column D isn't actually "3A " or
something similar? That's all I can think of. Sam "NEHicks" wrote: I am using the following formulas to count the occurrence of units: =SUM(($F$555:$F$1085="")*($D$555:$D$1085="5A")). This formula will recognize all units except 3A. Then it returns 0, which I know is incorrect. In a separate formula: =(COUNTIF($K$555:$K$1085,"5A")), where K555 is showing "=D555", this formula will also not recognize 3A but will recognize everything else. Both column D and K are formatted as General. Has anyone heard of this kind of a problem? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula won't recognize data
spaces before/after???
-- Don Guillett Microsoft MVP Excel SalesAid Software "NEHicks" wrote in message ... I am using the following formulas to count the occurrence of units: =SUM(($F$555:$F$1085="")*($D$555:$D$1085="5A")). This formula will recognize all units except 3A. Then it returns 0, which I know is incorrect. In a separate formula: =(COUNTIF($K$555:$K$1085,"5A")), where K555 is showing "=D555", this formula will also not recognize 3A but will recognize everything else. Both column D and K are formatted as General. Has anyone heard of this kind of a problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need formula that recognize | Excel Discussion (Misc queries) | |||
| How to recognize changes in slope of data? | Excel Discussion (Misc queries) | |||
| cells don't recognize formula | Excel Worksheet Functions | |||
| recognize formula | Excel Worksheet Functions | |||
| Formula to recognize Duplicates | Excel Worksheet Functions | |||
Hybrid Mode
