Sum or Sumifs Formulars

[Johnyam54]

HI Team,

Could someone please assist to update my formulars so that column "C" will automate with the relevant actuals % when the months unfolds with the actuals. please see file attached.

Please confirm whether you can see my attached file, as this is my first question.

Thanks
John

[JohnTopley]

in C4

=SUMIFS($F4:$Q4,$F$2:$Q$2,"Actuals")/SUMIFS($F$17:$Q$17,$F$2:$Q$2,"Actuals")

or

=SUMPRODUCT(($F4:$Q4)*($F$2:$Q$2="Actuals"))/SUMPRODUCT(($F$17:$Q$17)*($F$2:$Q$2="Actuals"))

Copy down

[Johnyam54]

Thanks very much John