Chemical Forums

Please login or register.

Login with username, password and session length

Sponsored links

Pages: [1]   Go Down

Author Topic: Boxcar averaging excel  (Read 2920 times)

0 Members and 1 Guest are viewing this topic.

bu2012

  • Regular Member
  • ***
  • Mole Snacks: +0/-0
  • Offline Offline
  • Posts: 19
Boxcar averaging excel
« on: October 01, 2011, 10:09:46 AM »

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?
Logged

sjb

  • Global Moderator
  • Sr. Member
  • ***
  • Mole Snacks: +173/-36
  • Offline Offline
  • Gender: Male
  • Posts: 2755
Re: Boxcar averaging excel
« Reply #1 on: October 01, 2011, 10:16:39 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?

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

Pages: [1]   Go Up
 

Mitch Andre Garcia's Chemical Forums 2003-Present.

Page created in 0.096 seconds with 24 queries.