Sum if (year to date)

[audrey]

Hello,

What I am trying to isonce user select the month from athe dropdown menu in C3

(lets assume "Sep" is selected)

O6 (YTD) should take the average of C:K

(lets assume "Feb" is selected)

O6 (YTD) should take the average of C:D

is that possible without macros ?

 

[Marcelo Branco]

Maybe

=AVERAGE($C6:INDEX($C$6:$N$6,MATCH(C3,$C$5:$N$5,0)))

 

[audrey]

works perfect thanks!

 

[Marcelo Branco]

works perfect thanks!

You are welcome and tks for the feedback

M.