01Oct2014

How to lookup a value with multiple criteria in a table?

Ever wondered how to lookup multiple criteria in excel? We will tell how you can do that. Excel provides a function called DGET which lets you to lookup multiple criteria. Let us know more about DGET. DGET DGET function in Microsoft Excel extracts a single value from a column of a list or a database
  • 1 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • dget, multiple lookup,
Read more
30Sep2014

SUMIF and SUMIFS

SUMIF: SUMIF function in Microsoft Excel, adds the cells specified by a criteria. Syntax for this excel function =Sumif(range, criteria, sum range) Sumif formula can be used in Microsoft Excel to add all values against a single criteria. Let’s take an example, here we have a data table of Sales persons and their sales numbers.
  • 30 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • sumif, sumifs,
Read more
29Sep2014

COUNTIF and COUNTIFS

COUNTIF: The COUNTIF function in Microsoft Excel counts the number of cells within a range that meet a single criterion that you specify. For example, let’s create a table of Employees and their work hours. We are interested in finding the number of employees who work more than eight hours, this can be easily done
  • 29 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • countif, countifs,
Read more
29Sep2014

DMIN and DMAX

DMIN and DMAX functions fall under Database functions in Microsoft Excel. These Excel functions are used to find specific information based on given criteria.
  • 29 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • dmax, dmin,
Read more
29Sep2014

Enable Macros for Excel VBA Files

Macros in Microsoft Excel should be enabled to run Excel file with macros. Following blog will help us in understanding how to do it. Let’s open the Microsoft Excel File which contains Macros (they are also called as VBA code).  When this type of file is opened, Excel pops up a warning notification as “Protected
  • 29 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • macros, vba,
Read more
<< Newer Posts