Excel - Rolling Average on multiple Sheets #Value Error

Asked Apr 12 '22 at 19:20

Active Apr 12 '22 at 19:20

Viewed 21 times

I am trying to get average on Sheet#1 as Data entered from sheet 2- sheet13 For example : Output result should be rolling average of Cell - G2 from Sheet 2 - Sheet13 Every month Data added and result should change as rolling average. following syntax gives #value error =IF(Data2!G2=" "," ",AVERAGE(Data!G2:Data1!G2)) in this case i am trying to Skip Sheet - Data2 and retrive result of average Sheet - Data +Data1

Thankyou

asked Apr 12 '22 at 19:20

Prakriti

You have the range as Data!G2 to Data1!G2. Is that across two sheets or your error? – Solar Mike Apr 12 '22 at 19:23
Data!G2:Data1!G2 is the range -Which need to average every month . Example (Jan-Dec) – Prakriti Apr 12 '22 at 19:29
I was able to figure out the results – Prakriti Apr 12 '22 at 20:51

Excel - Rolling Average on multiple Sheets #Value Error

0 Answers0