Excel List/Function Problem

  • Thread starter Thread starter inferno
  • Start date Start date
I

inferno

Just to let you know, I'm a huge beginner with Excel. I've never had th
need to use a spreadsheet program, so beyond basic math functions I'
unable to use it for any real purpose. I've tried figuring this out o
my own using the help file and function descriptions, but I'm just no
able to. So, if someone could help, I would really appreciate this.

I have data in a number of columns, and I want to preform a mat
function across to columns. For example, let's say I had 4 values i
column A and 4 values in column B. What I want is to have every valu
from column A multiplied by every value from column B, and then t
(hopefully) get some kind of list for all the products (which, in thi
scenereo, would be 16 seperate values).

In my case, I have 5 different columns, I need to perform differen
math functions (so, for example, i'll take something from column A, ad
it to something from column B, and then divide those by something fro
column C). What's the syntax for doing this? I tried writing simply:
-=((A1:A21)*(B1:B21))-
but that didn't work. I also tried experimenting using the CHOOS
function but that also didn't work. Any help would be appreciated
Thank you very much!

infern
 
Hi

One way would be =sum(a4:a8*b4:b8/c4:c8) and enterred as
an array formula Ctrl+ Enter
When you look in the formula bar
Excel will have placed Curley brackets around the formula
to show it has been entered as an array

Peter
(e-mail address removed)
 
Back
Top