1. Computing

Discuss in my forum

Ted French

Excel DMIN Function

By , About.com GuideSeptember 24, 2012

Follow me on:

Excel's database functions are designed specifically to work with an Excel database file.

For the most part, these functions are variations of commonly used Excel functions such as SUM, AVERAGE, MAX, and MIN.

The main difference between a regular function and its database counterpart - such as the MIN function and DMIN - is that DMIN lets you specify one or more criteria which act as data filters.

Only those records that match the conditions that you set are included in the calculations performed by DMIN.

Once the data has been filtered, DMIN will return the smallest or minimum value in a specific column of data.

To find out all the details, read this tutorial on the Excel DMIN function.

Related Tutorials

Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>
Top Related Searches dmin lunes septiembre

©2013 About.com. All rights reserved.