dsum

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

DSum

resolvedResolved · Low Priority · Version 2003

Brett has attended:
Excel Advanced course

DSum

I'm struggling with setting Criteria correctly. I think it is this part where I am going wrong "the range includes a colum label and one cell below the label for a condition". Is there anyway I can get a copy of our exercise worksheets from the training session last week to work back over some of those examples - I think that will help put me right. At the moment I am close but no cigar.

Brett.

RE: DSum

Hi Brett

Thanks for your question

Follow the link below for the files in question

https://www.stl-training.co.uk/download/trainer/courseware/excel_2003_advanced.zip


Regards

Stephen

Wed 25 Aug 2010: Automatically marked as resolved.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.08 secs.