I'm creating a template for a coworker, and I need to sum a column in a given sheet. The fields are usually entered by pasting the information from a different location, and these numbers are never the same every month. The easy solution would be to put the sum above the data, but I'm trying to do things right.

From all the research I've done so far, the cleanest solution seems to be to add a scroll bar, but that doesn't seem like it's intended for what I'm doing.

Oh, and this template will have four sheets with the same layout (one for each week a month), if that makes any difference.

For reference, up to now, she (and all other account executives) are doing things the hard way. Most things are hard coded and written out manually each week/month.


Thanks in advance for any help.