Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by like data
Question how can I use the SUM command to have it list the grand total for a
wtn everytime time it changes? Example data WTN BillAMt 1111111 1.00 1111111 4.26 1111111 5.32 1111111 8.62 2222222 9.36 2222222 83.20 2222222 15.20 2222222 8.20 End result WTN BIllAmt 1111111 19.20 2222222 115.96 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by like data
Use either pivot table or datasubtotal
-- Regards, Peo Sjoblom "expicitd" wrote in message ... Question how can I use the SUM command to have it list the grand total for a wtn everytime time it changes? Example data WTN BillAMt 1111111 1.00 1111111 4.26 1111111 5.32 1111111 8.62 2222222 9.36 2222222 83.20 2222222 15.20 2222222 8.20 End result WTN BIllAmt 1111111 19.20 2222222 115.96 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by like data
If your data is sorted so that all like WTNs are continuous, use Data
Subtotals. Select your data, then Data Subtotals. Use the drop-downs to apply Sum to BillAmt on changes of WTN. Note that this will use function 9 (sum) of the subtotal function. (You could also create a pivot table, dropping WTN into the rows field and BillAmt in the data field). --Bruce "expicitd" wrote: Question how can I use the SUM command to have it list the grand total for a wtn everytime time it changes? Example data WTN BillAMt 1111111 1.00 1111111 4.26 1111111 5.32 1111111 8.62 2222222 9.36 2222222 83.20 2222222 15.20 2222222 8.20 End result WTN BIllAmt 1111111 19.20 2222222 115.96 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by like data
If WTN is in column A and BillAMt is in column B, use:
=SUMIF(A1:A100,"111111",B1:B100) =SUMIF(A1:A100,"222222",B2:B100) -- Regards, Dave "expicitd" wrote: Question how can I use the SUM command to have it list the grand total for a wtn everytime time it changes? Example data WTN BillAMt 1111111 1.00 1111111 4.26 1111111 5.32 1111111 8.62 2222222 9.36 2222222 83.20 2222222 15.20 2222222 8.20 End result WTN BIllAmt 1111111 19.20 2222222 115.96 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by like data
The problem with Data Subtotal is copying the end result to a txt file is
all the the data is copy over not just the subtotals (end result) "bpeltzer" wrote: If your data is sorted so that all like WTNs are continuous, use Data Subtotals. Select your data, then Data Subtotals. Use the drop-downs to apply Sum to BillAmt on changes of WTN. Note that this will use function 9 (sum) of the subtotal function. (You could also create a pivot table, dropping WTN into the rows field and BillAmt in the data field). --Bruce "expicitd" wrote: Question how can I use the SUM command to have it list the grand total for a wtn everytime time it changes? Example data WTN BillAMt 1111111 1.00 1111111 4.26 1111111 5.32 1111111 8.62 2222222 9.36 2222222 83.20 2222222 15.20 2222222 8.20 End result WTN BIllAmt 1111111 19.20 2222222 115.96 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by like data
how do i create a pivot table?
"Peo Sjoblom" wrote: Use either pivot table or datasubtotal -- Regards, Peo Sjoblom "expicitd" wrote in message ... Question how can I use the SUM command to have it list the grand total for a wtn everytime time it changes? Example data WTN BillAMt 1111111 1.00 1111111 4.26 1111111 5.32 1111111 8.62 2222222 9.36 2222222 83.20 2222222 15.20 2222222 8.20 End result WTN BIllAmt 1111111 19.20 2222222 115.96 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum by like data
See http://peltiertech.com/Excel/Pivots/pivotstart.htm
-- HTH RP (remove nothere from the email address if mailing direct) "expicitd" wrote in message ... how do i create a pivot table? "Peo Sjoblom" wrote: Use either pivot table or datasubtotal -- Regards, Peo Sjoblom "expicitd" wrote in message ... Question how can I use the SUM command to have it list the grand total for a wtn everytime time it changes? Example data WTN BillAMt 1111111 1.00 1111111 4.26 1111111 5.32 1111111 8.62 2222222 9.36 2222222 83.20 2222222 15.20 2222222 8.20 End result WTN BIllAmt 1111111 19.20 2222222 115.96 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |