I have tried to follow the answer given to the question “6.3.1.2 Sum function in formula bar now activates a drop down menu” (12 sept 2019) but i was not able to find the operator “SUM” (sigma in greek alphabet). I was in Tool>Customize but i did not find it.
Can you help me?
Hello,
prerequesite: View > [x} Formular Bar
is activated.
Hope that helps.
Update [according to comment of OP]
To add the SUM function into a toolbar, you need to customize a toolbar. To do so, perform
Tools -> Customize
- Select tab
Toolbars
- Enter
Sum
into the search field. - Select Function Sum from the **Function" list
- Select a Target toolbar (or create a new target; e.g. MyToolbar)
- Click the right arrow to add the function to the toolbar
- Click button
OK
If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.
Thank you but I was not clear: I have the formula bar active, but I don’t like the “SUM sub menù”. I would like to insert only “SUM” in other places (like toolbar for example) as answered in the question that I have mentioned, but I am not able to do it. Coul somebody help me?
thank you very much