Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
select a column, then add rows of each column
First - Worksheet recipients will need to select only 1 of the following
columns: Column A, has value of 1 Column B, has value of 2 Column C, has value of 4 Then - Need to have formula to add total value of each column |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
select a column, then add rows of each column
Do you mean formula to sum an entire column
=SUM(A:A) If this post helps click Yes --------------- Jacob Skaria "darcy" wrote: First - Worksheet recipients will need to select only 1 of the following columns: Column A, has value of 1 Column B, has value of 2 Column C, has value of 4 Then - Need to have formula to add total value of each column |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
select a column, then add rows of each column
Eventually yes, I need to add the value of each column. But first is there a
way to put a check box or button in each cell that allows the user to select ONLY ONE of the three columns at a time. And when the selection is made I want a specific value to be assigned to that cell (as indicated below). Then I need to add the total 'value' for each column. "Jacob Skaria" wrote: Do you mean formula to sum an entire column =SUM(A:A) If this post helps click Yes --------------- Jacob Skaria "darcy" wrote: First - Worksheet recipients will need to select only 1 of the following columns: Column A, each cell has value of 1 Column B, each cell has value of 2 Column C, each cell has value of 4 Then - Need to have formula to add total value of each column |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
select a column, then add rows of each column
Column A, each cell has value of 1
Column B, each cell has value of 2 Column C, each cell has value of 4 ... is there a way to put a check box or button in each cell that allows the user to select ONLY ONE of the three columns at a time. And when the selection is made I want a specific value to be assigned to that cell (as indicated below). Then I need to add the total 'value' for each column. The following doesn't work exactly how you describe, but it's close and it uses basic Excel features. First, enter these text values: In E1: A In E2: B In E3: C Column D will have a pull-down in each cell to choose A, B, or C. To do this, select column D and use Data Validation Settings Allow: List Source: =$E$1:$E$3 Check "Ignore blank" Check "In-cell dropdown" Error Alert Style: "Stop" Check "Show error alert ..." Select column D and use: Format Cells Border to put borders around the cells to suggest that's where the user makes the input choices. Enter these formulas: In F1: =SUM(A:A) In F2: =SUM(B:B) In F3: =SUM(C:C) In A1: =IF(D1="A",1,"") In B1: =IF(D1="B",2,"") In C1: =IF(D1="C",4,"") Select A1:C1 and copy down for as many rows as needed. The totals for the columns are in E1:F3. Error checks can be added (in column G, say) to detect if the user erroneously types into columns A:C. Better yet, read up on "protection" in Excel's built-in Help. Modify to suit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select data in non adjacent rows of a column automatically | Excel Discussion (Misc queries) | |||
Help tonight?!! select rows based on cell value in a column | Excel Worksheet Functions | |||
select rows to print where there's data in specific column | Excel Discussion (Misc queries) | |||
Need to select rows to average based on a value in a different column | New Users to Excel | |||
In Excel: select the last 20 rows of data in a column | Excel Worksheet Functions |