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?