The formula’s below have their own resultant cell, and I want it to record a blank until one or more contributing cells in the range for the formula is populated. Right now the resultant cell populates with a zero.

To capture attendance:
=COUNTIFS($D205:$D250,"ATTENDANCE",G205:G250,1)

To Capture the highest rating
=MAX(G217:G252)

To Capture the combined ratings
=SUMIF($D217:$D252,"WEEKLY TOTALS",G217:G252)