Is it possible to have formulas that work even if some cells in between are
empty of dollar values? Not every row will necessarily have a dollar
amount. The sheet in question has a section that involves subtraction but
it only works if previous rows are not empty and they are filled one after
the other. In other words, if any rows contain cells that are empty of
value, subsequent calculations underneath don't work.

Was hoping someone could tell me if a) possible to re-write formulas to do
calculations correctly adjusting for any blank cells, and b) what term I can
search for in the archives that will do this?

Thanks.