98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals
Subtotals
Resolved · Low Priority · Version 2003
Natalie has attended:
Excel Intermediate course
Excel Advanced course
Subtotals
how would you subtotal date and text columns
RE: subtotals
Hi Natalie
Sorry for not getting back to you before
The answer to this is sort your data by the date column
then click the sort assending toolbar button
then go to the data menu - and subtotal - choose date from at each change in
choose a count function as this will tell you how many there are - you will need this to do what you want as most of the other function are for number function
Hope this helps
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
Mon 1 Dec 2008: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create own ribbon tab - Excel 2010a. In Excel click on the File tab |