I think the formula is =SUMIFS(D6:AH6,D3:AH3,"7"). Hence in UiPath I recommend you place the formula in a text file =SUMIFS(D<C2>:AH<C2>,D<C1>:AH<C1>,"7"), then read the file & do a .Replace("<C2>", YourCounter).Replace("<C1>", YourCounterVariable), then use the resulting string to write to cell.
Hope that helps ! Kudos 
Regards,
Nithin
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu