Thread: [Solved] Variable data set in Average formula
View Single Post
 
Old 09-16-2017, 01:16 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Into B2 enter the formula
=AVERAGE(OFFSET($A$1;ROW()-1;;;$C$2-1;1)
and copy down.
Reply With Quote