Hello all,
I'm new and have a mathematical problem I can't seem to solve despite a lot of head scratching. I feel like I'm not too far away but I just can't make the breakthrough.
I'm analysing data which can't be converted from text. Therefore I have to use contain formulas to identify months and years. Because of this I can't simply calculate the volume by month and year as they are separate.
How can I calculate per month and year with the below information ?
Objective: Be able to identify volume for each month/year (Jan-2016...etc)
Thank you in advance for your help !
I'm new and have a mathematical problem I can't seem to solve despite a lot of head scratching. I feel like I'm not too far away but I just can't make the breakthrough.
I'm analysing data which can't be converted from text. Therefore I have to use contain formulas to identify months and years. Because of this I can't simply calculate the volume by month and year as they are separate.
How can I calculate per month and year with the below information ?
Jan | 4 | 2016 | 88 |
Feb | 25 | 2017 | 127 |
Mar | 75 | 2018 | 29 |
Apr | 7 | ||
May | 88 | ||
Jun | 3 | ||
Jul | 0 | ||
Aug | 0 | ||
Sep | 0 | ||
Oct | 1 | ||
Nov | 41 | ||
Dec | 0 |
Objective: Be able to identify volume for each month/year (Jan-2016...etc)
Thank you in advance for your help !