LOOKUP NUMBERS

7+ WAYS TO LOOKUP NUMBER VALUES

Crispo Mwangi | 5-Oct-17 | 2 Comments

The ability to lookup number values in excel is a must have for all data analysts. Some Excel users just know the basic VLOOKUP function but there are 7 more functions to lookup values. The more lookup function you know the better you become in retrieving numbers like sales for a certain month, a balance for a […]

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 […]