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

dsum

ResolvedVersion 2003

Jonathan has attended:
Project Intro Intermediate course
Project Advanced course
Excel Advanced course

DSUM

How do I use the DSUM function

RE: DSUM

Hi Jonathan,

Thank you for your question.

There are three arguments:

1. Database (range of cells that make up your data list including headings).
2. Field (Which field do you want to sum).
- Can be a column index number or the name of the column heading in speech marks.
3.Criteria range - This area consists of headings which are copied from the main list and pasted somewhere else on the sheet. Type the criteria required under each of the copied headings.

e.g. dsum(a1:h41,"Salary",L1:P3)

I hope this answers your question.

Regards

Simon

Wed 28 Oct 2009: Automatically marked as resolved.

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.