I'm using Excel 2016 on a PC.
Down one column I used the IMSUB function to subtract 12 from each value inputted. I then wanted to SUM for a total of all the remaining values shown (after IMSUB calculation was applied) in a bottom cell. The SUM function won't work at all. It either gives me 0 or the total I got in the final IMSUB cell in the column. The IMSUB column works perfectly. I'm a medium experienced user of Excel, I can do stuff many other people can't do, but this has me completely confused. Surely if I write =SUM(F3:F33) I should get the total of all the values in this range, whether they have been influenced by an IMSUB calculation or not?
I have tried the Error Checking function and it came up with nothing. I have tried inputting the autosum and selecting the cells in different ways, I even manually entered F3,F4,F5 and so on just to see but no joy.
Please help, I don't understand what is happening here does anyone have any ideas or come across this before?