Try

=SUMIF(D4:D54,"Solar",T4:T54)/SUMPRODUCT((D4:D54,"Solar")*(T4:T54>0))