Excel Array formula

[danomaniac]

Hey gang.
I'm having trouble getting an array formula to work right in excel. I have three rows of data. The top row is a percentage and the bottom two are whole numbers. I want to add the numbers in the 2nd and 3rd rows and multiply by the percentage in the 1st row for each column of data sets.

Row 1: 10%, 20%, 15%, 25% etc.
Row 2: 5, 5, 10, 5 etc.
Row 3: 100, 85, 75, 95 etc.

((100+5)*10%) + ((85+5)*20%) + ((75+10)*15%) etc...

any help would be appreciated.



"It's more like it is now, than it ever has been."

 

[SkipVought]

Dan,

for the example you posted
[tt]
{=SUM((B2:E2+B3:E3)*B1:E1)}
[/tt]
entered as an array

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[byundt]

danomaniac,
You can also use SUMPRODUCT in a regular formula to do the same job:
=SUMPRODUCT(A1:A10*B1:C10)

Brad