Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|