daverage-functions

DAVERAGE vs AVERAGEIF & DCOUNT vs COUNTIF

Crispo Mwangi | 4-Dec-16 | Leave a Comment

We have been exploring on database functions for the last two articles ( EXCEL DATABASE FUNCTION and EXCEL DSUM FUNCTION.) This article will examine  DAVERAGE & DCOUNT and how they compare with their equivalent AVERAGEIFS & COUNTIFS. Will the Database functions prevail in terms of speed over their IFS equivalent? DAVERAGE vs AVERAGEIFS For example using below data compute the […]

dsum

EXCEL DSUM FUNCTION

Crispo Mwangi | 9-Nov-16 | 2 Comments

If you are new to Database Functions, read this Introduction to Database Functions first before you continue. In this article we shall look into the uses of DSUM function which is one of the EFFICIENT Excel sum functions with criteria. Below are some of its uses; 2 way lookup Summarizing Results based on criteria 2 Way […]

database-functions

EXCEL DATABASE FUNCTION

Crispo Mwangi | 5-Nov-16 | Leave a Comment

Since their introduction in Excel 2007, DataBase functions have remained Overlooked & Underutilised. This is an Introduction in a  Series of articles whose aim is to demystify these Database functions. Database functions include; DSUM, DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DGET, DPRODUCT, DSTDEV, DSTDEVP, DVAR, DVAR. All these functions works basically the same way and have […]