Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to get a sub-total of amounts when...
When I sort a simple list of contributions (for instance) and it groups say
weekly contributions to an organization, is it possible to get a sub-total for that grouping??? If so, how? Thanks |
#2
|
|||
|
|||
Is it possible to get a sub-total of amounts when...
If the list you want to sort went from B1:B1000, in B1001 try:
=SUBTOTAL(9,B1:B1000) Regards, Alan. "marsha" wrote in message ... When I sort a simple list of contributions (for instance) and it groups say weekly contributions to an organization, is it possible to get a sub-total for that grouping??? If so, how? Thanks |
#3
|
|||
|
|||
Is it possible to get a sub-total of amounts when...
I would like to understand this but I am too much of a novice.
If the column B is the companies (that are sorted) and column C is the amounts. Exactly how do I make Excel 2003 do that? Thanks Alan!! "Alan" wrote in message ... If the list you want to sort went from B1:B1000, in B1001 try: =SUBTOTAL(9,B1:B1000) |
#4
|
|||
|
|||
Is it possible to get a sub-total of amounts when...
You can use the Subtotal command --
Select a cell in the table Choose Data Subtotals From the first dropdown, choose Companies In the Add subtotal to list, add a check mark to Amount Click OK marsha wrote: I would like to understand this but I am too much of a novice. If the column B is the companies (that are sorted) and column C is the amounts. Exactly how do I make Excel 2003 do that? Thanks Alan!! "Alan" wrote in message ... If the list you want to sort went from B1:B1000, in B1001 try: =SUBTOTAL(9,B1:B1000) -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Is it possible to get a sub-total of amounts when...
"Debra Dalgleish" wrote in message ... You can use the Subtotal command -- Select a cell in the table Choose Data Subtotals From the first dropdown, choose Companies In the Add subtotal to list, add a check mark to Amount Click OK Thanks Debra, I will try this tomorrow when brain is alive. And I will be sure to let you know how I do! Thanks again to all, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I total amounts on various sheets in excel? | Excel Worksheet Functions | |||
Percent of total in Pivot tables | Excel Worksheet Functions | |||
Linking total amounts | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
sumproduct to add total amounts for the month | Excel Worksheet Functions |