Hi,

I think you right it probably is a 'simple macro' if a macro is even
necessary but I'm afraid I don't understand the question

Each row consists of an item (therefore the number of rows will vary),

Please explain the above a bit more clearly and perhaps a small sample of
data with the answer you expect.

Mike

"Lost" wrote:

I need a macro that does the following:

Each row consists of an item (therefore the number of rows will vary), I
need to drag a formula down a column (dragged down depending on the number of
items are entered in) through the last item. Then I need a sum on those
totals.

Please help! Thanks!