Moving data to the right and up.

  • Thread starter Thread starter yh73090
  • Start date Start date
Y

yh73090

17:57:00 4/3/2004 18:09:00 0.20
18:11:00 4/3/2004 18:15:00 0.07
Daily Total : 0.27

This is a sample of the data in a spreadsheet.

The "Daily Total:" and the sum "0.27" is what I need help with.

I would like to move the content in both cells (which are in their ow
columns) to the right in and up one row.

Each of these line items have a unique ID# that is not here but is in
cell for each line item.

The ID#'s vary in rows.

Is this possible
 
You could delete the rows that contain the daily totals, then use a
SUMIF formula to total each ID.

To delete the daily total rows:

Select a column in which all rows will have an entry, except rows
that contain the daily total. In your example, column A could be
selected.
Choose Edit>Go To, click Special
Select 'blanks', click OK
Choose Edit>Delete
Select 'Entire Row', click OK

To total each ID:
Add a heading in cell E1, e.g. 'Daily Total'
In cell E2, enter a formula that refers to your range of data:
=IF(A2=A3,"",SUMIF($A$2:$A$23,A2,$E$2:$E$23))
Copy the formula down to the last row of data
 
Back
Top