Skip to Main Content
Microsoft Excel Functions & Formulas
book

Microsoft Excel Functions & Formulas

by Bernd Held
September 2006
Beginner to intermediate content levelBeginner to intermediate
397 pages
13h 15m
English
Jones & Bartlett Learning
Content preview from Microsoft Excel Functions & Formulas
Chapter 8
Database Functions ........................199
Use the DCOUNT function to count special cells ..............200
Use the DCOUNT function to count cells in a range between x and y ...202
Use the DCOUNTA function to count all cells beginning
with the same character..........................203
Use the DGET function to search for a product number ..........204
Use the DMAX function to find the most expensive product in a category . 205
Use the DMIN function to find the least expensive product.........206
Use the DMIN function to find the oldest person on a team ........207
Use the DSUM function to sum sales of a period ..............208
Use the DSUM ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel - Advanced Formulas And Functions

Microsoft Excel - Advanced Formulas And Functions

Guy Vaccaro

Publisher Resources

ISBN: 9781598220117