Sorting Subtotals
I'd add another column and use a formula on each row that essentially did the
subtotal for that group. Yep, you'd see the subtotal on each row of that group.
You may be able to use a function like =sumif() or =sumproduct() or =sumifs() to
do the subtotal.
Katy wrote:
I have a spreadsheet that I am subtotaling. Most of the subtotals are zero,
but I am only concerned with the subtotals that are not. I need to keep the
detail. How can I segregate what has a zero total from another subtotal
without manually looking through the spreadsheet and copying and pasting? I
have already tried sorting by the total column, but it won't let me. FYI, I
am using Excel 2007.
Thanks!!
--
Dave Peterson
|