Calculating the Volume per Month

[GuyW]

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 ?

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 !

 

[Dr.Peterson]

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 ?

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 !

I don't understand what you want to do. Why can't the data be "converted from text"? Do you want to change the month names to numbers and can't? What would you need to do with them? And is "contain formulas" a typo for "certain formulas", or something?

More important, what do the numbers represent? I suppose they are volumes per month and per year; but are they volumes for each month in some particular year, and the total for each year? The monthly numbers don't add up to any of the yearly numbers, so I can't make sense of that. And the data you give don't provide enough information to tell the volume in any given month of any given year.

Finally, what is the goal? If you want the average number per month, you don't need any text; just add up the numbers and divide by 12. And, again, if you want the volumes in each month over three years, the data just isn't there.