Hi there,
Below is my data set and I want to update columns ending "Total Value" with a formula that multiply columns ending "Number of shares" and "Share price". I assume we need to use Multi-row Formula, but not sure what functions to use so that it would match the Award number in calculating the Total value. Many thanks in advance.
| | Award 1 Number of shares | Award 1 Share price | Award 1 Date | Award 1 Total Value | Award 2 Number of shares | Award 2 Share price | Award 2 Date | Award 2 Total Value | Award 3 Number of shares | Award 3 Share price | Award 3 Date | Award 3 Total Value |
| Person A | 100 | $5 | 5/06/2019 | | 200 | $7 | | | 50 | $4 | | |
| Person B | 200 | $6 | 6/01/2019 | | 100 | $5 | | | 100 | $7 | | |
| Person C | | | | | | | | | | | | |
| etc. | | | | | | | | | | | | |
