REally you need to copy the staff member names down so your table looks more
like this

Staff 1
Staff 1 data number Total
Staff 1 data number

Staff 2
Staff 2 data number Total
Staff 2 data number
Staff 2 data number
Staff 2 data number
Staff 3
Staff 3 data number Total
Staff 3 data number
Staff 3 data number

After that getting the subtotals is not that terribley difficult. Yu could
use subtotaling, pivot tables or even array formulas. Not sure which would be
your favorite so I will let you decide that. To poplulate the first column do
this

Staff 1 is in cell A4. In cell A5 put the formula =A4. Copy cell A5. Now
select all of row a which contains the staff members. A4 - A1000. Hit F5.
Click on the Special Cells Button. Check off Blank cells. All of the blank
cells will now be highlighted. Now paste the formula. (Ctrl + v). Your first
column should now be filled in. Copy and paste special values so that your
formulas become hard coded values and you should be off to the races...

HTH

" wrote:

Morning, I have a column of data (numbers) which extend down between
rows 4 to 1000, the length varies month to month. The collected data
in sepearated by spaces per staff members. I need to total the
activity for that staff member. See below.

Staff 1
data number Total
data number

Staff 2
data number Total
data number
data number
data number
Staff 3
data number Total
data number
data number
Ect.

As you can see the third column has the values I need to total for each
staff member to place in the first available row in column 4. But since
the number of values are difference from staff member to staff member I
can not figure out how to sum the column?

Thanks