Attached sheet need a formula to array, divide and multiply. Please also include a formula that will auto include more rows when data is added.
| Name | Dance x 3 | Jump x 2 |
|---|---|---|
| Ali | 4 | 8 |
| Val | 2 | 6 |
| Ali | 6 | 8 |
| Val | 8 | 4 |
- Eg.
- Ali Dance = ((4+6)/2)x3 = 15
- Ali Jump = ((8+8)/2)x2 = 16
Result I want.
| Name | Count |Dance x 3 | Jump x 2 |
|:—- |:——:|:——:| —–:|
| Ali |2 | 15 | 16 |
| Val |2 |15 | 10 |