Dsum/Daverage etc functions

Resolved · Low Priority · Version 2007

Tue 27 Oct 2009, 10:39 Delegate Stuart said...

Stuart has attended:
Excel Intermediate course
Excel Advanced course

Dsum/Daverage etc functions

How many of these functions are there? And what do they all do please?

Tue 27 Oct 2009, 15:53 Trainer Amanda said...

RE: Dsum/Daverage etc functions

Hello Stuart

Thank you for your question.

DSUM and DAVERAGE are part of a group of functions referred to as Database functions. There are 12 database functions in total. Searching for database functions in Excel help will give you a list of each function and a description of what each one does.

Each database function is designed to summarise contained within a database/list in slightly different ways.

Kind regards
Amanda

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips