How do I add functions to the sum dropdown menu?

G

Guest

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??
 
B

Bob Phillips

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)
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard 8
how can i enter a formula to tabulate the sum of drop down menu r. 2
How do I add up the last 12 cells (containing values) in a column. 4
how do i add dropdown menus to a menu bar? 1
How do I sum a range which includes the "#N/A" VLOOKUP return valu 6
How do I add multiple conditions to a formula? 3
How do I add the Adobe PDF, and Acrobat Comments dropdown toolbar 1
How do I add a second criteria to the SUMIF or DSUM function? 2

Top