Hello guys,
I have got a questions regarding different calculations based on the selection of the drop-down list. In other words, how can I have different calculations based on what variable I select in the drop-down-list?
For example, let's say I've got 5 companies and I created a drop-down list where I can select one company.
<tbody>
</tbody>
Then I got the data like sales per week and a variable total sales:
<tbody>
</tbody>
<tbody>
</tbody>
Now I would like to calculate total sales, which is Sum(Mon:Fri), but based on what Company I select in the drop down list e.g. if I select Company A, it should calculate Sum(21:21), if I select Company B then Sum(24:11) and so on.
How can I make it happen in excel?
Thanks a lot!
I have got a questions regarding different calculations based on the selection of the drop-down list. In other words, how can I have different calculations based on what variable I select in the drop-down-list?
For example, let's say I've got 5 companies and I created a drop-down list where I can select one company.
Company A |
Company B |
Company C |
Company D |
Company E |
<tbody>
</tbody>
Then I got the data like sales per week and a variable total sales:
Sales per week | Mon | Tue | Wed | Thu | Fri |
Company A | 21 | 12 | 31 | 12 | 21 |
Company B | 24 | 26 | 21 | 26 | 11 |
Company C | 12 | 15 | 12 | 17 | 12 |
Company D | 12 | 11 | 31 | 27 | 21 |
Company E | 21 | 22 | 26 | 15 | 12 |
<tbody>
</tbody>
Total sales |
<tbody>
</tbody>
Now I would like to calculate total sales, which is Sum(Mon:Fri), but based on what Company I select in the drop down list e.g. if I select Company A, it should calculate Sum(21:21), if I select Company B then Sum(24:11) and so on.
How can I make it happen in excel?
Thanks a lot!