Calculating Dynamicly Average
Hi there ,
İ need a formula for a dynamic calculation , i added a sample as below , lets explain what i need ;
At below table yellow field area contains August 2023 datas, white field area contains September 2023 datas , imagine that every each month , i amm adding new lines to this table also , So i have a dynamic tabe infact , i need to calculate per month'a average under the average column
how is it calculating ? I calculate total of price column all each month's and divide price with related line.
For example ;
for first line ( Material A ) average calculating = 100 / 100+200+300 = 0,17
for second line ( Material B) average calculating = 200 / 100+200+300 = 0,33
for fourth line ( Material D ) average calculating = 40 / 40+50+60 = 0,27 (above two line was belong to August Data now for this line i need to divide September's total)
every month i have many lines that i add to my sheet , i want that calculating will be related for each month and it's year , i dont want to do this calculating manually every month , is there any way to put under Average cell a formula to make this calculation automaicly ?
Thanks in advance for your kind supports .
Help Article Resources
Check out the Formula Handbook template!