| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Key for Calculating Average?
Is there a way, beyond using the pull-down, to calculate an average of cells?
I'm looking for either a function key or shortcut key method. Please advise ASAP. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function Key for Calculating Average?
Highlight the cells you want to average
On the very bottom of the Excel window, you'll see probably see (on the right), something that says SUM=xxx.xx where the xxx is your total. Right click that, and choose average from the list. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: Is there a way, beyond using the pull-down, to calculate an average of cells? I'm looking for either a function key or shortcut key method. Please advise ASAP. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function Key for Calculating Average?
I was actually looking for a keyboard shortcut, as it takes longer to
pull-down & select like I've been doing. Thanks anyway. "Ken Puls" wrote: Highlight the cells you want to average On the very bottom of the Excel window, you'll see probably see (on the right), something that says SUM=xxx.xx where the xxx is your total. Right click that, and choose average from the list. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: Is there a way, beyond using the pull-down, to calculate an average of cells? I'm looking for either a function key or shortcut key method. Please advise ASAP. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function Key for Calculating Average?
Ken wasn't talking about the pull down or down arrow beside AutoSum.
Epinn "robin" wrote in message ... I was actually looking for a keyboard shortcut, as it takes longer to pull-down & select like I've been doing. Thanks anyway. "Ken Puls" wrote: Highlight the cells you want to average On the very bottom of the Excel window, you'll see probably see (on the right), something that says SUM=xxx.xx where the xxx is your total. Right click that, and choose average from the list. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: Is there a way, beyond using the pull-down, to calculate an average of cells? I'm looking for either a function key or shortcut key method. Please advise ASAP. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function Key for Calculating Average?
Hi Robin,
I wrote up an article on my site to more clearly describe what I was talking about. Set this feature once, and it should be very quick to use. http://www.excelguru.ca/node/82 HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: I was actually looking for a keyboard shortcut, as it takes longer to pull-down & select like I've been doing. Thanks anyway. "Ken Puls" wrote: Highlight the cells you want to average On the very bottom of the Excel window, you'll see probably see (on the right), something that says SUM=xxx.xx where the xxx is your total. Right click that, and choose average from the list. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: Is there a way, beyond using the pull-down, to calculate an average of cells? I'm looking for either a function key or shortcut key method. Please advise ASAP. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function Key for Calculating Average?
thank you! - I printed out your article.
"Ken Puls" wrote: Hi Robin, I wrote up an article on my site to more clearly describe what I was talking about. Set this feature once, and it should be very quick to use. http://www.excelguru.ca/node/82 HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: I was actually looking for a keyboard shortcut, as it takes longer to pull-down & select like I've been doing. Thanks anyway. "Ken Puls" wrote: Highlight the cells you want to average On the very bottom of the Excel window, you'll see probably see (on the right), something that says SUM=xxx.xx where the xxx is your total. Right click that, and choose average from the list. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: Is there a way, beyond using the pull-down, to calculate an average of cells? I'm looking for either a function key or shortcut key method. Please advise ASAP. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function Key for Calculating Average?
Ken,
That's very efficient of you. I like that feature and I have been using it for quite a few months now. I use it to count so I don't see SUM. If a user had "none" chosen, he/she would not see anything displayed. I hope they know they can just right-click anywhere on the taskbar towards the right half of the screen to bring up the pull down list. Today I experiment some more and realize that COUNT actually counts text, numbers, special signs, nulls etc. The only thing not counted is a true blank. Null is treated as text or non-blank. I wish there is a way to capture whatever displayed into a cell. Probably asking for too much? Epinn "Ken Puls" wrote in message ... Hi Robin, I wrote up an article on my site to more clearly describe what I was talking about. Set this feature once, and it should be very quick to use. http://www.excelguru.ca/node/82 HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: I was actually looking for a keyboard shortcut, as it takes longer to pull-down & select like I've been doing. Thanks anyway. "Ken Puls" wrote: Highlight the cells you want to average On the very bottom of the Excel window, you'll see probably see (on the right), something that says SUM=xxx.xx where the xxx is your total. Right click that, and choose average from the list. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: Is there a way, beyond using the pull-down, to calculate an average of cells? I'm looking for either a function key or shortcut key method. Please advise ASAP. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function Key for Calculating Average?
Will this feature average cells on different worksheets? Haven't tried it,
but that's what I need to do on 13 different worksheets. "Epinn" wrote: Ken, That's very efficient of you. I like that feature and I have been using it for quite a few months now. I use it to count so I don't see SUM. If a user had "none" chosen, he/she would not see anything displayed. I hope they know they can just right-click anywhere on the taskbar towards the right half of the screen to bring up the pull down list. Today I experiment some more and realize that COUNT actually counts text, numbers, special signs, nulls etc. The only thing not counted is a true blank. Null is treated as text or non-blank. I wish there is a way to capture whatever displayed into a cell. Probably asking for too much? Epinn "Ken Puls" wrote in message ... Hi Robin, I wrote up an article on my site to more clearly describe what I was talking about. Set this feature once, and it should be very quick to use. http://www.excelguru.ca/node/82 HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: I was actually looking for a keyboard shortcut, as it takes longer to pull-down & select like I've been doing. Thanks anyway. "Ken Puls" wrote: Highlight the cells you want to average On the very bottom of the Excel window, you'll see probably see (on the right), something that says SUM=xxx.xx where the xxx is your total. Right click that, and choose average from the list. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca robin wrote: Is there a way, beyond using the pull-down, to calculate an average of cells? I'm looking for either a function key or shortcut key method. Please advise ASAP. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Using text for the range in AVERAGE function | Excel Worksheet Functions | |||
| Figuring daily average...function ??? | Excel Worksheet Functions | |||
| Average function assistance | Excel Discussion (Misc queries) | |||
Hybrid Mode
