Running Average...?

[JustOneQuestion]

Hi all,

I have a sheet that I track weekly hours on. I built a slicer, so I just 'slice' the table to view each week.

I have the names in column B, the total hours for that person in column J, and I have the weekly YTD average in column K. I am trying to not have to manually add the following week into the average formula each week...
For example - Right now I am manually adding whatever cell the next week falls on. =Average(J4, J39, J52) and so on...

I have toyed with the IF and search functions.. But have been unsuccessful.

I am trying to get excel to look up in column b, the name, then average the total that is in column J each week. Anyone know if that is possible? Below is an example of 2 weeks.

Below is an example of 2 weeks.

Daily Hours
	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Weekly Total
Bob	10.25​			10.25​	12.25​	10.25​	10​	53​	YTD Avg hours
Billy	11.5​			10.5​	12​	12.25​	11.75​	58​	49.5​
Steve	10​	3.5​	9.25​	10.5​			7​	40.25​	52​
Joe	10.5​			11​	11​	8.5​	11.5​	52.5​	41.5​
Frank		13​		13.75​	13​	10.5​	13.25​	63.5​	53.5​
Daily Hours
	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Weekly Total	YTD Avg hours
Bob	11.25​			11.75​		10.75​	12.25​	46​	49.5​
Billy	8.25​				13.25​	13​	11.5​	46​	52​
Steve	10​	3.75​	10.25​	9.5​			9.25​	42.75​	41.5​
Joe	10​			12.25​	12.25​	10​	10​	54.5​	53.5​
Frank		13.25​		13.75​	12.25​	13.75​	13.25​	66.25​	64.875​

 

[Peter_SSs]

Does this do what you want?

Book1
	B	C	D	E	F	G	H	I	J	K
2		Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Weekly Total	YTD Avg hours
3	Bob	10.25			10.25	12.25	10.25	10	53	49.5
4	Billy	11.5			10.5	12	12.25	11.75	58	52
5	Steve	10	3.5	9.25	10.5			7	40.25	41.5
6	Joe	10.5			11	11	8.5	11.5	52.5	53.5
7	Frank		13		13.75	13	10.5	13.25	63.5	64.875
8
9	Daily Hours
10		Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Weekly Total	YTD Avg hours
11	Bob	11.25			11.75		10.75	12.25	46	49.5
12	Billy	8.25				13.25	13	11.5	46	52
13	Steve	10	3.75	10.25	9.5			9.25	42.75	41.5
14	Joe	10			12.25	12.25	10	10	54.5	53.5
15	Frank		13.25		13.75	12.25	13.75	13.25	66.25	64.875
Average

Cell Formulas
Range	Formula
K3:K7, K11:K15	K3	=AVERAGEIF(B$3:B$200,B3,J$3:J$200)

 

[JustOneQuestion]

Works like a charm. I was trying to over-complicate things... thank you!!

 

[Peter_SSs]

Works like a charm. I was trying to over-complicate things... thank you!!

You're welcome. Thanks for the follow-up.