Powerful Formula
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...
Powerful Excel Formula: INDEX MATCH
In a previous article, we discussed the VLOOKUP formula and how one of its major flaws was that it will only search from left to right and adding new columns into your search array can break your... More...
Microsoft Excel Functions: IF
The IF function is a powerful function that can generate an answer based on set criteria IF tests a criteria and returns a value if the test is true, and another value if the test is... More...
Microsoft Excel Functions: SUMIF
The SUMIF function combines the SUM and IF functions to make a powerful formula SUMIF will sum all the values in a list based on a single criterion, which removes the need for manipulating the... More...
Microsoft Excel Functions: VLOOKUP
The VLOOKUP function is a fantastic function that can save you lots of time searching through data for values VLOOKUP searches for a value within an array and returns a corresponding value from a... More...