excel microsoft training - 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 » excel microsoft training - DSUM

excel microsoft training - DSUM

resolvedResolved · Low Priority · Version Standard

Claire has attended:
Excel Advanced course

DSUM

What does DSUM mean?

RE: DSUM

Dear Claire

Thank you for your question!!

D is the abbreviation for database. So DSum stands for Database Sum.

You may recall from the advanced course that you did with us that the most important part of any database function is the Criteria range.

Please refer to the uploaded file to understand the below demonstartion:

There are three parts to a database function:
a) Database
b) Field
c) Criteria

In the uploaded example:
We are trying to calculate the sum of salary in the accounts dept.
On Cell C1 we will put the DSUM function where:
A3: D7 is our database
D3 is our Field that we want the calculation performed
A1:A2 is our criteria range

There are few important things to remember when you deal with Database functions.
It is advisable to copy and paste the fields from your database when you are creating your criteria range as any spelling mistake in the criteria range will give you either a wrong answer or an error!!

Also in the Field box you can either type in the Column letter or the call reference or the name of the heading that needs to be calculated.

I hope this helps:

Please let me know if you have any thing that you might want me to clarify further!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003





 

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.09 secs.