I know Autosum. Is there an "automultiply" shortcut?

[James C]

Alt+= gives the sum for above (or left) contiguous values

QUESTION: does excel have an "automulitply" shortcut that multiplies instead of adds?

[Bernard Liengme]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bernard Liengme]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>