ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add functions to the sum dropdown menu? (https://www.excelbanter.com/excel-worksheet-functions/133942-how-do-i-add-functions-sum-dropdown-menu.html)

slb1170

How do I add functions to the sum dropdown menu?
 
I'm doing a lot of stats in excel where I use st dev and median values. The
dropdown menu attached to the sum button doesn't contain those functions
(only average, min, max, etc.).

Customizing toolbars won't let me into the menus "far enough", if you know
what I mean, to add them.

Can this be done??

Bob Phillips

How do I add functions to the sum dropdown menu?
 
Why not just add them to right-click, Cell?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"slb1170" wrote in message
...
I'm doing a lot of stats in excel where I use st dev and median values.
The
dropdown menu attached to the sum button doesn't contain those functions
(only average, min, max, etc.).

Customizing toolbars won't let me into the menus "far enough", if you know
what I mean, to add them.

Can this be done??




Bernard Liengme

How do I add functions to the sum dropdown menu?
 
The AutoSum button has only a limited number of functions.
For all the functions use the Function Insert tool. In Excel 2003 click the
"fx " to the right of the Formula Bar, or use menu command Insert |
Function.

You are going to find Excel a bit exasperating until you know some basics.
May I suggest you get a book such as Excel for Dummies to get started?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"slb1170" wrote in message
...
I'm doing a lot of stats in excel where I use st dev and median values.
The
dropdown menu attached to the sum button doesn't contain those functions
(only average, min, max, etc.).

Customizing toolbars won't let me into the menus "far enough", if you know
what I mean, to add them.

Can this be done??





All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com