Formula
 

I have a speadsheet- Each column is a different value. Each row is a diffent
person. I want to be able to put an X in the column by the name of the
person. I want this X to be the value of the column. Then I want to be able
to add all the X's and get their totals to the right. THANKS IN ADVANCE!!!

2 2 2 4 1 2
NAME X X = 6
NAME X X X = 5

--
Thanks Pam

Formula
 

Hi,
I assumed that the values are in row1 from column C to E then in column F
enter the formula as follow

=SUMPRODUCT(--(C2:E2="x"),$C$1:$E$1)

Change the range to fit your needs

If this helped please click yes, thanks


"Pamrich" wrote:

I have a speadsheet- Each column is a different value. Each row is a diffent
person. I want to be able to put an X in the column by the name of the
person. I want this X to be the value of the column. Then I want to be able
to add all the X's and get their totals to the right. THANKS IN ADVANCE!!!

2 2 2 4 1 2
NAME X X = 6
NAME X X X = 5

--
Thanks Pam

Formula
 

Thank you so much............
--
Thanks Pam


"Eduardo" wrote:


Hi,
I assumed that the values are in row1 from column C to E then in column F
enter the formula as follow

=SUMPRODUCT(--(C2:E2="x"),$C$1:$E$1)

Change the range to fit your needs

If this helped please click yes, thanks


"Pamrich" wrote:

I have a speadsheet- Each column is a different value. Each row is a diffent
person. I want to be able to put an X in the column by the name of the
person. I want this X to be the value of the column. Then I want to be able
to add all the X's and get their totals to the right. THANKS IN ADVANCE!!!

2 2 2 4 1 2
NAME X X = 6
NAME X X X = 5

--
Thanks Pam