I am working on a large spread sheet. Occasionally, it is necessary insert
rows through columns which have already been formatted. Typically, some
columns are totaled (summed) at the bottom. In the past, I have
occasionally noticed (I think) that the sum of a column which has had a row
inserted is incorrect if the inserted row is not formatted before a value is
placed in it. The value is generally place by dragging a logic function
into the cell.

Not sure I'm explaining this clearly, but does any of this make sense?

If, indeed, that is what I have done (to quite a bit of data), is there any
way to reformat a cell, that has had a function dragged into it, so that
it's contents will contribute to the various totals? In fact, do I even
have to do that?

Thx

Dave