Forum Discussion
Solved
How to use different selected cells in a formula
I want to use all the cells selected by go to function in a product formula. Is it possible? If yes, then how?
If, by a 'go to function', you mean a multi-area range manually selected using 'Go to Special' then it is possible to name the range while it is selected. Not many functions accept multi-area ranges as parameters but
=PRODUCT(values)
should work.
If, by a 'go to function', you mean a multi-area range manually selected using 'Go to Special' then it is possible to name the range while it is selected. Not many functions accept multi-area ranges as parameters but
=PRODUCT(values)
should work.