Variable data set in Average formula

		Microsoft Office Forums > Microsoft Excel > Excel
Variable data set in Average formula

FAQ

Thread Tools

Display Modes

09-16-2017, 10:36 PM

xor

Windows 10 Variable data set in Average formula

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

I would use (in B2 and copy down)

=IF(ROW(2:2)-$C$2<0;"";AVERAGE(OFFSET($A$2;ROWS($1:1);;-$C$2)))

on condition you use semicolon as argument separator.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling a range variable into a formula	Officer_Bierschnitt	Excel Programming	3	11-23-2015 03:30 AM
Looking for formula that would create an average from certain criteria with in excel	bdouglas1011	Excel Programming	7	07-29-2014 08:16 AM
formula to find 2 or more criterias then average the sum	samtitus	Excel	6	02-17-2014 10:16 PM
Excel 2010 formula rounds - arithmetic average calculation	YooNaa Kim	Excel	1	06-07-2011 08:50 PM
'AVERAGE' Formula	nfphilpot	Excel	3	11-24-2010 02:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 PM.