Alt+= gives the sum for above (or left) contiguous values
QUESTION: does excel have an "automulitply" shortcut that multiplies instead of adds?
Alt+= gives the sum for above (or left) contiguous values
QUESTION: does excel have an "automulitply" shortcut that multiplies instead of adds?
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" <James.C.1wm9qa_1128830700.9982@excelforum-nospam.com> wrote in
message news:James.C.1wm9qa_1128830700.9982@excelforum-nospam.com...
>
> 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
>
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" <James.C.1wm9qa_1128830700.9982@excelforum-nospam.com> wrote in
message news:James.C.1wm9qa_1128830700.9982@excelforum-nospam.com...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks