Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel spread sheet sums not showing up
example: I have a sum for the amount of time people worked with clients. it
shows up when all the clients are showing. but if I only show one client, then no sums show up for that client, only the time worked on any given day, is there a way to make the sum show up that totals all the time for the client worked to date? -- thank you, LM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel spread sheet sums not showing up
How is the data organised that you are summing and what formula(s) do you use?
"Lorie" wrote: example: I have a sum for the amount of time people worked with clients. it shows up when all the clients are showing. but if I only show one client, then no sums show up for that client, only the time worked on any given day, is there a way to make the sum show up that totals all the time for the client worked to date? -- thank you, LM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel spread sheet sums not showing up
=subtotal(9,j3:j23)
I would like it if i didn'thave to limit it to J23 but it would sum up what ever was in that column. But like i said when i sort to one person that one persons sub totals don't show up at all, only when I have everyones showing up..... -- thank you, Lorie "Toppers" wrote: How is the data organised that you are summing and what formula(s) do you use? "Lorie" wrote: example: I have a sum for the amount of time people worked with clients. it shows up when all the clients are showing. but if I only show one client, then no sums show up for that client, only the time worked on any given day, is there a way to make the sum show up that totals all the time for the client worked to date? -- thank you, LM |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel spread sheet sums not showing up
I'm guessing that you used Data|Filter and Data|Subtotals at the same time.
If you filter to hide the details, then =subtotal() will ignore the hidden rows. Either drop the filter (and use the outlining symbols to the left) or drop the data|subtotals. Maybe you can use row 1 to show the subtotals: =subtotal(x,A3:A###) kind of formulas. Lorie wrote: example: I have a sum for the amount of time people worked with clients. it shows up when all the clients are showing. but if I only show one client, then no sums show up for that client, only the time worked on any given day, is there a way to make the sum show up that totals all the time for the client worked to date? -- thank you, LM -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing sums/totals for 1 client when printing or in print preview | Excel Discussion (Misc queries) | |||
showing dropdown selection arrows in spread sheets | Excel Discussion (Misc queries) | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
Showing sums horizonatlly, groups vertically | Excel Discussion (Misc queries) | |||
Excel Spread Sheet | Excel Discussion (Misc queries) |