YTD and Period Averages? Possible averageif with index/match?

[reacon84]

Hi all,

I have some weekly cost data, split into periods.

In cell B8, I'd like the YTD average, based on the period selection in B1.
In cell B9, I'd like the period average, based on the period selection in B1.

For example, if I changed B1 to period "2", B8 would change to "150", and B9 would change to "200".

I feel some sort of averageif with index/match is needed, but can't seem to find a way to make it work!

Thanks in advance.

Period:	3
Week	1	2	3	4	5	6	7	8	9	10	11	12
Period	1	1	1	1	2	2	2	2	3	3	3	3
Cost	100	100	100	100	200	200	200	200	300	300	300	300
YTD:	200
Period:	300

 

[hagia_sofia]

Hello, do you mean:

=AVERAGEIFS(B6:M6,B4:M4,"<="&B1)

=AVERAGEIFS(B6:M6,B4:M4,B1)

 

[reacon84]

It's always the simplest solution haha! Thank so much - I was really overcomplicating it.