Worksheet function needed
 

Greetings,
I have 7 cells that are"Weighted" as follows

Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3

In Cell 8 i need a function that will add the weight of each cell and
muliply by the value of each cell for example

if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i
should also mention that not all 7 cells will have a value but atleat one
will, Can this be done in a function or should i do it programmaticlly?

Worksheet function needed
 

if
cell1 is A1
cell2 is A2
cell3 is A3
cell4 is A4
cell5 is A5
cell6 is A6
cell7 is A7

then in A8 enter:
=A1+2*A2+3*A3+2*A4+3*A5+2*A6+3*A7

--
Gary''s Student - gsnu200791


"Office_Novice" wrote:

Greetings,
I have 7 cells that are"Weighted" as follows

Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3

In Cell 8 i need a function that will add the weight of each cell and
muliply by the value of each cell for example

if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i
should also mention that not all 7 cells will have a value but atleat one
will, Can this be done in a function or should i do it programmaticlly?

Worksheet function needed
 

Thank you.

"Gary''s Student" wrote:

if
cell1 is A1
cell2 is A2
cell3 is A3
cell4 is A4
cell5 is A5
cell6 is A6
cell7 is A7

then in A8 enter:
=A1+2*A2+3*A3+2*A4+3*A5+2*A6+3*A7

--
Gary''s Student - gsnu200791


"Office_Novice" wrote:

Greetings,
I have 7 cells that are"Weighted" as follows

Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3

In Cell 8 i need a function that will add the weight of each cell and
muliply by the value of each cell for example

if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i
should also mention that not all 7 cells will have a value but atleat one
will, Can this be done in a function or should i do it programmaticlly?

Worksheet function needed
 

Would this work?

=SUMPRODUCT(A1:A7,{1;2;3;2;3;2;3})
(=13)

--
HTH :)
Dana DeLouis


"Office_Novice" wrote in message ...

Greetings,
I have 7 cells that are"Weighted" as follows

Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3

In Cell 8 i need a function that will add the weight of each cell and
muliply by the value of each cell for example

if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would = 13 i
should also mention that not all 7 cells will have a value but atleat one
will, Can this be done in a function or should i do it programmaticlly?

Worksheet function needed
 

A slightly easier way especially if there will be many cells

=SUMPRODUCT(A1:A7,{1;2;3;2;3;2;3})


--


Regards,


Peo Sjoblom


"Office_Novice" wrote in message
...
Thank you.

"Gary''s Student" wrote:

if
cell1 is A1
cell2 is A2
cell3 is A3
cell4 is A4
cell5 is A5
cell6 is A6
cell7 is A7

then in A8 enter:
=A1+2*A2+3*A3+2*A4+3*A5+2*A6+3*A7

--
Gary''s Student - gsnu200791


"Office_Novice" wrote:

Greetings,
I have 7 cells that are"Weighted" as follows

Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3

In Cell 8 i need a function that will add the weight of each cell and
muliply by the value of each cell for example

if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would =
13 i
should also mention that not all 7 cells will have a value but atleat
one
will, Can this be done in a function or should i do it programmaticlly?

Worksheet function needed
 

Oops! Just posted the same solution, I somehow missed your post Dana


--


Regards,


Peo Sjoblom


"Dana DeLouis" wrote in message
...
Would this work?

=SUMPRODUCT(A1:A7,{1;2;3;2;3;2;3})
(=13)

--
HTH :)
Dana DeLouis


"Office_Novice" wrote in message
...
Greetings,
I have 7 cells that are"Weighted" as follows

Cell1 = 1, Cell2 = 2, Cell3= 3, Cell4= 2, Cell5= 3, Cell6= 2, Cell7= 3

In Cell 8 i need a function that will add the weight of each cell and
muliply by the value of each cell for example

if cell 3 's value = 3 & cell 6 's value = 2 the cell 8' value would =
13 i
should also mention that not all 7 cells will have a value but atleat one
will, Can this be done in a function or should i do it programmaticlly?