# Formula

#### Microsoft Excel Formulas: LEN

LEN is a simple formula that is not often used, however, used correctly it can be used to simplify your workbooks More...

#### Microsoft Excel Functions: SUBTOTAL

The SUBTOTAL function returns the subtotal from a list or database in Excel. SUBTOTAL will give you instant answers for your filtered data More...

#### Microsoft Excel Formulas: SUMIFS

The SUMIFS function adds all the arguments that meet certain criteria More...

#### Microsoft Excel Functions: SUMPRODUCT

SUMPRODUCT is a function which multiplies the corresponding components in selected arrays, and returns the sum of those calculations More...

#### Microsoft Excel Functions: HLOOKUP

HLOOKUP is the lesser used cousin of VLOOKUP, but can be just as useful. Learning how to use HLOOKUP can help in situations where VLOOKUP will not work More...

#### Microsoft Excel Absolute and Relative Cell References

Cell references in Excel are a big deal, getting them correct can mean the difference between time saved and time lost scratching your head. More...

#### Microsoft Excel Formulas: CHOOSE

The CHOOSE function can return a value from a list of up to 254 arguments. It can also be a good alternative to a nested IF statement More...

#### Basic Microsoft Excel Functions: COUNTA

The COUNTA function counts the number of cells that are not empty in a range More...

#### Basic Microsoft Excel Functions: COUNT

The COUNT function counts the number of cells in a range that contain a number More...

#### Basic Microsoft Excel Functions: ROUNDDOWN

This article describes the =ROUNDDOWN formula and how to use it to round-down a set number of decimal places More...

#### Basic Microsoft Excel Functions: ROUNDUP

This article describes the =ROUNDUP formula and how to use it to round-up a set number of decimal places. More...

#### How To: Shade Alternate Rows in Excel

Help make your long data lists easier to read by shading alternate rows Below are two quick and easy methods to allow you to do just that which don’t involve manually shading the rows More...

#### Top 3 Articles From the Last 30 Days

Below are links to the Top 3 most read articles on the website over the last 30 days If you would like an article writing, please get in contact More...

#### How To Use IFERROR

Do you get fed up when your formulas return #N/A when performing a VLOOKUP calculation? Learning to use =IFERROR can help solve that More...