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