2 Week Rolling Average... HELP!

**jnswbc** · 11-09-2015, 01:27 PM

I am pretty beginner when it comes to Excel 2010.

On the WOH tab, column L "Avg 2 Wek Comp Vol" I need to average data for the past two weeks based on today's date.
This data will be based on the COMP column for every day on the Completed Work tab.
I do not want to see zeroes or the lovely DIV/0! error if data is present in some part of the range and not whole.

I'm not sure if a helper column is needed on the Completed Work tab in order to calculate the rolling average.
I have tried different suggestions from google and assorted tutorials but I would assume I'm not inputting the formulas correctly...

TESTER.xlsx

**bebo021999** · 11-09-2015, 01:48 PM

What if it was not enough 14 days counted from begining (i.e very first date 1-nov, today is 9-nov, 8 days is counted only)
Also, does AVERAGE ignore blank cell/or cell with zero or not?
Try to input some desired result.

**jnswbc** · 11-09-2015, 02:36 PM

bebo021999
What if it was not enough 14 days counted from begining (i.e very first date 1-nov, today is 9-nov, 8 days is counted only)
Then I would still want a result of that average.

Also, does AVERAGE ignore blank cell/or cell with zero or not?
I'm not sure what you're talking about.

Try to input some desired result.
My desired result is to see a rolling average of data on the woh tab in column L for the past two weeks based on todays date and the columns labeled "comp" on the completed work tab.

José Augusto
I need to pull the data from the completed work tab for each COMP column.

**José Augusto** · 11-09-2015, 01:51 PM

Or try this
=IFERROR(AVERAGEIF(C$2:I$2,">="&TODAY()-14,C3:I3),"")

Formula:

=IFERROR(AVERAGEIF(C$2:I$2,">="&TODAY()-14,C3:I3),"")

2 Week Rolling Average... HELP!

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

2 Week Rolling Average... HELP!

Re: 2 Week Rolling Average... HELP!

Re: 2 Week Rolling Average... HELP!

Re: 2 Week Rolling Average... HELP!

Thread Information

Users Browsing this Thread

Similar Threads

Rolling 8 week tracker

[SOLVED] 12 week rolling sum

Four week rolling average with varying number of entries

[SOLVED] Vlookup and rolling 4 week average

Rolling 3 week average based on weekday

Rolling 12 week calculations?!?!?

Rolling Average:week number;

Bookmarks

Bookmarks

Posting Permissions