Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - List Management

excel training courses - List Management

ResolvedVersion Standard

Thu 12 Jul 2007, 14:39 Delegate Tim said...

Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course

List Management

how do I enter a database function that sets multiple criteria and then counts theh number of cells that fulfils them?

Eg
counts the total number of salespeople whose total sales were greater than $10,000 and whose sales in quarter 3 were greater than $3,000.

Fri 13 Jul 2007, 12:45 Trainer Richard said...

RE: List Management

Try:

DCOUNT

You must have external criteria, like in Advanced queries.

See attachement for an example of how to set it up.

Attached files...

Training information:

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips