ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subtotal appears at the beginning instead of the end.... (https://www.excelbanter.com/excel-discussion-misc-queries/205519-subtotal-appears-beginning-instead-end.html)

sara b

Subtotal appears at the beginning instead of the end....
 
After manipulating a spreadsheet I received from someone, I want to subtotal
by item. My subtotals appear at the beginning of the item instead of at the
end. The grand total appears at the top of the spreadsheet instead of at the
bottom. Can anyone tell me why this is happening and what I need to do in
order to correct?

Thomas [PBD]

Subtotal appears at the beginning instead of the end....
 
Sara B,

When you do your subtotals, are you ensuring that the button for "Summary
below data" is checked?
DataSubtotalsSummary Below Data

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"sara b" wrote:

After manipulating a spreadsheet I received from someone, I want to subtotal
by item. My subtotals appear at the beginning of the item instead of at the
end. The grand total appears at the top of the spreadsheet instead of at the
bottom. Can anyone tell me why this is happening and what I need to do in
order to correct?


sara b

Subtotal appears at the beginning instead of the end....
 
Thank you! I looked at this for a long time and never realized that wasn't
checked!

"Thomas [PBD]" wrote:

Sara B,

When you do your subtotals, are you ensuring that the button for "Summary
below data" is checked?
DataSubtotalsSummary Below Data

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"sara b" wrote:

After manipulating a spreadsheet I received from someone, I want to subtotal
by item. My subtotals appear at the beginning of the item instead of at the
end. The grand total appears at the top of the spreadsheet instead of at the
bottom. Can anyone tell me why this is happening and what I need to do in
order to correct?


Thomas [PBD]

Subtotal appears at the beginning instead of the end....
 
You're welcome and thanks for the feedback.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"sara b" wrote:

Thank you! I looked at this for a long time and never realized that wasn't
checked!

"Thomas [PBD]" wrote:

Sara B,

When you do your subtotals, are you ensuring that the button for "Summary
below data" is checked?
DataSubtotalsSummary Below Data

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"sara b" wrote:

After manipulating a spreadsheet I received from someone, I want to subtotal
by item. My subtotals appear at the beginning of the item instead of at the
end. The grand total appears at the top of the spreadsheet instead of at the
bottom. Can anyone tell me why this is happening and what I need to do in
order to correct?



All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com