Can a blank cell be assigned a number from another cell? Working on this today.

[OCcat]

I have a huge election and will be using Excel to tally the votes. Each member has a different percentage interest and there are three votes per member. The candidates names are in the top row and I have each percentage down the first column.

Is there a way to assign all cells in each individual row with that percentage value from the first column so when I get a vote and type an X into the cell, it will automatically know that X equals the percent assigned?
Then in the "total" cell in the very bottom row, I would just do =sum(), select the whole column, and it would add up all of those different percentages that were assigned.

I don't know what version of Excel I have at work, sorry!
I am working on this today for the meeting on Monday so any help you have is greatly appreciated! Thanks!

[TMS]

Try SUMIF. It would look something like:

=SUMIF(B2:B7,"x",$A$2:$A$7)


Regards, TMS

[OCcat]

That is probably exactly what I am looking for, but can you go into a bit more detail please? This is what I have so far-

A2- percentage
B2, C2, D2 need to be assigned the number from A2.

Thanks for responding so quickly to my question!

[ChemistB]

I'm not so sure that Trevor's solution is what you are looking for. Can you upload an example worksheet of what you have and what you want? (Go Advanced>Manage Attachments)

Are you saying that if you type an "X" into D2 (for example), it will automatically place the value in A2 into D2?
That will require a short VBA solution.

[TMS]

@ChemistB: I don't think anything sophisticated is needed.

If your percentages start in cell A2 down, then the total in column B is: =SUMIF(B2:B7,"x",$A$2:$A$7) ... adjust the 7 to be the last row of data.

Then drag the formula across. Column A is fixed but column B will auto adjust.

[OCcat]

I have included my example- I think you guys know what I am looking to do, put an x into the name column when someone gets a vote, then the total should go into the very bottom cells. I can do the totaling by hand with the =sum() once all the votes have been put in.

I thought I had decent excel knowledge but apparently not so, so thank you SO much the helping me with this and walking me though it!.

Where exactly do I insert the formula?

"Are you saying that if you type an "X" into D2 (for example), it will automatically place the value in A2 into D2?
That will require a short VBA solution."
Yes, this is what I need.

[OCcat]

Election.xlsxI have included my example- I think you guys know what I am looking to do, put an x into the name column when someone gets a vote, then the total should go into the very bottom cells. I can do the totaling by hand with the =sum() once all the votes have been put in.

I thought I had decent excel knowledge but apparently not so, so thank you SO much the helping me with this and walking me though it!.

Where exactly do I insert the formula?

"Are you saying that if you type an "X" into D2 (for example), it will automatically place the value in A2 into D2?
That will require a short VBA solution."
Yes, this is what I need.

[TMS]

You need a worksheet change event, if that is what you want to do:

Please Login or Register  to view this content.

Regards, TMS

[ChemistB]

To use Trevor's code
Right click on the worksheet tab > "View Code" (opens the VBA editor)
Paste code into large white text box on right
Close window.

Playing Thread tag with TMShucks