Formula for totalling specific options
I have a sheet for a menu of options. We are building kits of different swag items and the sheet has 5 different options with different price breaks. I'd like a sales rep to be able to go in and select different options then see a kit price.
I was thinking I could add a check box column then pull a report on that checkbox. However, I need to show a total of the items selected and I don't think a report can do that. Here are the rows and columns for reference:
Is there a formula that I could put at the bottom of the sheet for each column that sums up the numbers in that column if there is a trigger? For example, if I add a check box column. Then the formula for the 100 Cost column would add up the figures in the three rows if the checkbox for that row is checked?
Or is there a way to do something with conditional formatting maybe? Or forms? Just some way for a rep to come in and see if they choose coffee mug option 2, water bottle option 5 and journal option 1 what the kit total would be at the different quantity points.
Thanks in advance for your help!