Function a dropdown which allows to add to a list

SamBrown1000 

To create a spreadsheet in Excel on Mac that allows you to select cuts of carpet from a dropdown list and then calculates the sum of the selected cuts, you can use Excel's Data Validation and SUM functions. Here is a step-by-step guide:

Step 1: Set Up Your Spreadsheet

1. In one column (let us say column A), create a list of all the available cuts of carpet. You can use cells A2, A3, A4, and so on to list the cuts.
2. In another column (e.g., column B), you can set up the dropdown list. Select the cell where you want the dropdown to appear (e.g., cell B2).

Step 2: Create the Dropdown List

1. In cell B2, go to the "Data" tab in the Excel ribbon.
2. Select "Data Validation."
3. In the Data Validation dialog box:
• Choose "List" from the "Allow" dropdown.
• In the "Source" field, enter the range of cells containing your carpet cuts (e.g., $A$2:$A$100).
4. Click "OK" to create the dropdown list in cell B2.

Step 3: Calculate the Sum

1. In a cell where you want to display the sum of the selected cuts (e.g., cell C2), you can use the SUM function. Enter the following formula in cell C2:

=SUMIF($A$2:$A$100, B2, YourRangeOfCarpetValues)

Replace YourRangeOfCarpetValues with the range where you have the corresponding carpet values or sizes. For example, if the values are in column D from D2 to D100, you would use $D$2:$D$100.

Step 4: Use the Dropdown

Now, you can select cuts of carpet from the dropdown in cell B2, and the sum of the selected cuts will be displayed in cell C2.

Whenever you select a different cut from the dropdown, the sum in cell C2 will automatically update based on your selections.

You can extend this setup to add more rows for additional selections if needed, and the sum will update accordingly. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.