| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I know Autosum. Is there an "automultiply" shortcut?
Alt+= gives the sum for above (or left) contiguous values QUESTION: does excel have an "automulitply" shortcut that multiplies instead of adds? -- James C ------------------------------------------------------------------------ James C's Profile: http://www.excelforum.com/member.php...o&userid=12114 View this thread: http://www.excelforum.com/showthread...hreadid=474543 |
|
#2
|
|||
|
|||
|
Do you really need Auto tool? Why not type =SUMPRODUCT(range)
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "James C" wrote in message ... Alt+= gives the sum for above (or left) contiguous values QUESTION: does excel have an "automulitply" shortcut that multiplies instead of adds? -- James C ------------------------------------------------------------------------ James C's Profile: http://www.excelforum.com/member.php...o&userid=12114 View this thread: http://www.excelforum.com/showthread...hreadid=474543 |
|
#3
|
|||
|
|||
|
OOOPS! too early for the brain cells. The correct formula is =PRODUCT(range)
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "James C" wrote in message ... Alt+= gives the sum for above (or left) contiguous values QUESTION: does excel have an "automulitply" shortcut that multiplies instead of adds? -- James C ------------------------------------------------------------------------ James C's Profile: http://www.excelforum.com/member.php...o&userid=12114 View this thread: http://www.excelforum.com/showthread...hreadid=474543 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autosum returns an incorrect zero value on the selected cells | Excel Worksheet Functions | |||
| Autosum | Excel Discussion (Misc queries) | |||
| Autosum box too big | Excel Worksheet Functions | |||
| autosum ?? | Excel Worksheet Functions | |||
| autosum problems | Excel Worksheet Functions | |||
Linear Mode
