YTD calculation

[rdev]

Please see the file attached
I want to input a formula in cell C5 which will sum data from C2 through to G2. If Mar is selected in C4 then cells C2 to E2 should be added

https://drive.google.com/open?id=1g38lnSEv13xtBiWygeUWddjIRLmTPzLP

The second argument of the sum function should be dynamic
Any suggestion how to proceed

 

[steve the fish]

Something like:

=IF(ISNUMBER(MATCH(C4,C1:N1,0)),SUM(C2:INDEX(C2:N2,MATCH(C4,C1:N1,0))),0)