A description of your layout would be helpful.

In general, you do the following:
1. Calculate the sum for one item, as in: =sum(a2:l2)
2. Drag this cell down as many items as you have. Excel will automatically
adjust the calculation for you. The easiest way to drag is to grab the fill
handle (the black box on the bottom right of the cell), and drag is as far
as you need. Then release the cursor.

Regards,
Fred

"bizee" wrote in message
...
I have a list of items, each of those now needs 12 rows (one for each
month). How can I do this without manually doing so. The list of
items is well over 200.