Can Empty Rows Be Ignored When Sum Is Used?

I have reports that some fields are empty. When the rows contain no blank or empty fields the sum totals work perfectly.

My question: Is there a way to ignore those empty fields and still achieve the sum total of the column? Any suggestions or comments are well appreciated.

Below are the examples of my concern:

1. No empty fields, the column totals work.

Screen Shot 2020-01-29 at 5.20.32 PM2302×838 114 KB

2. Rows with empty fields, the column totals fail.

Screen Shot 2020-01-29 at 5.21.12 PM2290×1510 346 KB