Oct 21 2021 09:05 PM
=SUMIF (RangeToApplyCriteria, YourCriteria, sum_range)
Considering the B2:B20 the range where you may have "blank cells" and C2:C20 the range containing the values you want to sum, use the following formula
=SUMIF(B2:B20,"",C2:C20)
Find attachment