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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...et.f unctions
- Jun 04 Wed 2008 20:44
Excel subtotals should subtotal quot;blanksquot; separately.
close
全站熱搜
留言列表
發表留言
留言列表

