Skip to next row, but include skipped row in total calculation

I'm trying to not have a row published if the expenditure type is null.

But I still need that row added to the end totals in the next row.

The row I want skipped has a loop over the expenditure type - displaying the expenditure type column and then six amount columns (in the same row).  I want this entire row to not show up when the expenditure type is null (the row exists, but the expenditure type just has no name), but I still need its costs added up in the next row, which are the totals for the loop over the expenditure type.