Chemical Forums
Specialty Chemistry Forums => Other Sciences Question Forum => Topic started by: bu2012 on October 01, 2011, 04:09:46 PM
-
I am trying to figure out how to boxcar average on excel. I need to box car average 3 and I have about 300 numbers to do, so doing each one every time is becoming very time consuming. So if I have number in B2:B4 that need to be averaged then B5:B7 need to be average and so on, how would I do so? I tried to drag it down after doing the first few, but it didn't work. Any suggestions?
-
I am trying to figure out how to boxcar average on excel. I need to box car average 3 and I have about 300 numbers to do, so doing each one every time is becoming very time consuming. So if I have number in B2:B4 that need to be averaged then B5:B7 need to be average and so on, how would I do so? I tried to drag it down after doing the first few, but it didn't work. Any suggestions?
Perhaps do something like IF(ROW(B2)/3=INT(ROW(B2)/3),AVERAGE(B1:B3),"")
and fill this all the way down. I may have the true / false values the wrong way round, but the intent is to put the average in each of the rows B3, B6, B9 etc...