If you select E35 & then drag the fill handle to P35, the formula will copy across & will update to the correct column so P35 will have
=SUM(P$14:P$15)