| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula giving wrong result
Why does this:
=SUMPRODUCT(--(MONTH(B$7:B$998)=1)) return 992 when the entire column B is empty? The other 11 permtations work as one would expect, but this particular one counts 'blank' as January! Any ideas? tia -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returning wrong result. | Excel Worksheet Functions | |||
| Sumif formula not giving result | Excel Discussion (Misc queries) | |||
| Formula not giving me the right result | Excel Worksheet Functions | |||
| FORMULA PRODUCES WRONG RESULT | Excel Discussion (Misc queries) | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Threaded Mode
