# Multiplying multiple columns based on current column

1. ## Multiplying multiple columns based on current column

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.?

2. ## Re: Multiplying multiple columns based on current column

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.

3. ## Re: Multiplying multiple columns based on current column

Originally Posted by NBVC
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.
Just term by term,

A B
2 3
3 4

=
6
12

4. ## Re: Multiplying multiple columns based on current column

So then

=PRODUCT(A1:A5) copied across?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1