Ask Your Question

ifelsethenend's profile - activity

2019-01-18 23:20:17 +0200 commented answer highlight all the cells used for a calculation used in another cell?

I'm sorry, last I used Excel was v2010 before ditching MS Office. As far as I can remember it was possible to see the ra

2019-01-18 23:02:03 +0200 commented answer highlight all the cells used for a calculation used in another cell?

Oh, I see. So I have to go into 'edit' mode to see the sum cell range highlighted. The same as double clicking really, a

2019-01-18 22:52:37 +0200 commented answer highlight all the cells used for a calculation used in another cell?

Sorry, but I have the same problem even when upgrading to v5.4.7.2 When selecting the Sum cell, the cell range that is

2018-10-02 05:08:33 +0200 received badge  Famous Question (source)
2018-02-07 23:01:32 +0200 received badge  Notable Question (source)
2017-10-29 00:49:06 +0200 received badge  Popular Question (source)
2017-10-28 22:31:30 +0200 answered a question Sum of cells that contain math formula

So I created a new document and it simply works as it should. I'm guessing something went wrong in the initial document

2017-10-25 17:25:31 +0200 asked a question Sum of cells that contain math formula

Sum of cells that contain math formula A cells contains a math formula, meaning it contains =234+3456-456 the value i