Placement of Subtotals within a Spreadsheet

W

wdo

I'm using a basic spreadsheet that is populated with column headers like address, work order, date, material description, quantity, and cost. I want the subtotal of the cost to show up in the imediate column to the right

When using the Subtotal command under the Data tab Excel automaticly places the subtotal under the group of cells being subtotalled. The data on the spreadsheet is too long to select every single subtotal then manually move them to the adjacent column . . . every month

I've also tried building a pivot table but I couldn't get the result I wanted there either. Of course using the "subtotal" command then trying to build a pivot table is not allowed in Excel, which would probably give me just what I want
 
P

Peo Sjoblom

You could use a formula and copy the formula down
in the column where you want this

=IF(ISNUMBER(FIND("Total",A2)),B2,"")

replace A2 with the first data in the (At each change in) column and B2
the first data in the column that gets the subtotals



--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

wdo said:
I'm using a basic spreadsheet that is populated with column headers like
Click to expand...
address, work order, date, material description, quantity, and cost. I want
the subtotal of the cost to show up in the imediate column to the right.
When using the Subtotal command under the Data tab Excel automaticly
Click to expand...
places the subtotal under the group of cells being subtotalled. The data
on the spreadsheet is too long to select every single subtotal then manually
move them to the adjacent column . . . every month.
I've also tried building a pivot table but I couldn't get the result I
Click to expand...
wanted there either. Of course using the "subtotal" command then trying to
build a pivot table is not allowed in Excel, which would probably give me
just what I want.
 
Top