Excel drop down boxes

[simon235]

How or what formula do i use to get a total sum or average value to display in a cell taking the information from a range of selections from drop down boxes.

thanks....simon

 

[PepeLeMokko]

One way ( which may not be the easiest) could be as follows :
1. For the comboboxes, choose the linked cells in the same column ( say A)
2. In col B next to the first use the Index function to retrieve the value chosen in the combobox pointing to the range you use for the box.
When choices have been made you can apply any functions you need on the value list created
For ex : range used for cbox1: c1:c12
Cbox 2 : d1:d12
Linked cell cbox1 : a1
Linked cell cbox2 : a2
Formula in cell b1: =index(c1:c12;a1;1)
Formula in cell b2: =index(d1:d12;a2;1)

b1 and b2 will now contain the values chosen in the cboxes.
The rest is as usual

 

[KenWright]

Are you talking about summing or averaging the cells that are a result of something like Data Validation, so for example you could have 10 ranges of data with 10 DropDowns that will return 10 single numbers, and you want to sum or average these 10 single numbers? If so then are the cells contiguous or are they spread across a sheet or even sheets?

Regards
Ken..........