I have the current problem, say I have X columns, A,B,...X, and 5 rows,
I need to multiply:
A1:A5*B1:B5*...*X1:X5
is there a way to do this without having to type in the C,D,E,F... columns etc.?
I have the current problem, say I have X columns, A,B,...X, and 5 rows,
I need to multiply:
A1:A5*B1:B5*...*X1:X5
is there a way to do this without having to type in the C,D,E,F... columns etc.?
Last edited by NBVC; 06-28-2010 at 03:32 PM. Reason: Solved based on rep given
It is not really clear what it is you are multiplying here?
Is it the sum of each of those ranges? Or is it just the product of all the cells in the entire range.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
So then
=PRODUCT(A1:A5) copied across?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks