Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel subtotals should subtotal "blanks" separately.
When we subtotal after changes in field-X, a blank value in field-X will
cause those records to be subtotalled in with the records from the last non-blank field. We think this is a malfunction, as the ensuing subtotals do not accurately represent the data situation, and that the records with the blank field should show a separate subtotal. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel subtotals cells with a formula - HELP | Excel Worksheet Functions | |||
copy subtotals to new excel 97 book | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Why won't Excel buttons show separately on the taskbar? | Excel Discussion (Misc queries) | |||
Excel should let you sort by subtotals | Excel Worksheet Functions |