Forum Discussion
Formules do not work
hi all,
When I insert formules to count the values of cells or if I want to refer to another cell, I get the wrong values/amounts.
I tried to count the amounts with the auto sum formula. It doenst work.
Anyone an idea how to solve this?
Thanks solo much in advance!
3 Replies
Hi,
AutoSum uses COUNT() function which count only the cells with numbers, all the rest are ignored. Is that your case?
hi it doesnt even count numbers.. while in other worksheets the formulas works at it should. I assume it is a settings-issue..?
If you check any of your cells which you try to count with ISNUMBER() what it returns?
