It is difficult to imagine that this is possible if there is no pattern. Is
there not any details in other cells that might indicate which cells to SUM?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"COE" wrote in message
...
Hi,

I am having trouble trying to work out how to sum some non-contiguous
ranges
in Excel 2000.

The data is on sheet 1. It is budget data for a number of employees.
There are 12 cells (one for each month), for four different categories,
for
each employee.

Eg, the category 1 (billing) data for employee 1 would have a range
something like:
d6;d22;d46;h6;622;h46;l6;l22;l46;p6;p22;p46
category 2 is one column over and would be...
e6;e22;e46;i6;i22 etc.

and so on for each category for each of 14 or so employees.

To make this more difficult, because employees are constantly changing,
there is no clear pattern to the rows that belong to each employee.

Is there an easy way for me to sum these ranges without having to click on
each and every cell holding down CTRL? If I do this, and someone deletes
a
row - it would wreck the totals, wouldn't it?

If I could have a list of the row numbers for each employee, and the
column
letters, and could combine these into cell references that would be great,
but I'm not sure if that is possible.

Does anyone have any suggestions how I could do this?

Cheers,
Caroline (COE)