Adding part of a column

[Mike375]

Is there a way in Excel that I can add part of a column, based on the cell entries in another column.

I know how to Sum a range of cells but I don't know how to handle the situation with rows being added or deleted or an entry in a reference cell being changed.

My ideal solution would be if I could have the equivalent of unbound text boxes at the bottom of an Access tabular form whereby adding or deleting records or different sorts are taken care of.

 

[shades]

Cross posted
________
TOYOTA F ENGINE SPECIFICATIONS

 

[Mike375]

Thanks for offer of help. Responded on dBForums