| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Result shows correct answer but cell shows 0
Hi everyone
I have been using the following formula =SUMPRODUCT(($D$2:$D$576=T39)*($P$2:$P$576="Yes")) which has been working well on all other columns ie M instead of P however using P the result shows as 2 (when you step through it) which is correct but when you hit enter the cell goes back to 0 - very strange - have checked format etc and all looks ok. any thoughts on this one please? -- Thanks as always Lise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The formula result is 76% but the cell shows 0%. Why? | Excel Discussion (Misc queries) | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| The formula shows in cell but not the result | Excel Discussion (Misc queries) | |||
| fx shows correct value but not cell | Excel Worksheet Functions | |||
| Cell shows only formula, no result | Excel Worksheet Functions | |||
Threaded Mode
