dsumdaverage etc functions

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/Daverage etc functions

Dsum/Daverage etc functions

resolvedResolved · Low Priority · Version 2007

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?

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


 

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


Server loaded in 0.08 secs.