subtotals
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals

Subtotals

resolvedResolved · Low Priority · Version 2003

replyReply Fri 7 Nov 2008, 16:36Delegate Natalie said...

Natalie has attended:
Excel Intermediate course
Excel Advanced course

Subtotals

how would you subtotal date and text columns

For upcoming training course dates see: Pricing & availability

replyReply Mon 24 Nov 2008, 16:37Trainer Mark said...

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.

 

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard