Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Intermitten Data in one Column
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting multiple Y column data versus single X column in Excel 20 | Charts and Charting in Excel | |||
How do I sort data in column B to align with data in column A? | New Users to Excel | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions |