Sum The Value of a Particular Range with Suffix Number by eliminating a Till Symbol Conten

Dear Experts,

Please find the attached File where I have daily production plan by individual FG Number.

Every Production Schedule is having the Prefix of “1=”, “2=”,”3=” Etc., Followed by Scheduled Quantity.

In Column AD2, I would want to sum the value Range of B2:AB2, Sum Formula has to consider the Value in Each Cell which is mentioned after “=” Symbol!

Few Expected Results are manually Updated in AD2, AD3 Cell

Looking forward your Input to Accomplish the same!

Thanks & Regards,
Rajeshkumar R