[bu2012]

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?

[sjb]

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...