Microsoft Excel Formulas: SUMIFS

6 March 2017 in Formula, Powerful Formula
0 comments 2 minutes 876 views

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

Tags: , , , ,

Microsoft Excel Functions: SUMPRODUCT

19 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 815 views

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

Tags: , , ,

Microsoft Excel Functions: HLOOKUP

13 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 1,059 views

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...

Tags: , , , ,

Powerful Excel Formula: INDEX MATCH

19 December 2016 in Powerful Formula
0 comments 3 minutes 729 views

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...

Tags: , , , , , ,

Microsoft Excel Functions: IF

11 December 2016 in Powerful Formula
0 comments 2 minutes 690 views

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...

Tags: , ,

Microsoft Excel Functions: SUMIF

21 October 2016 in Powerful Formula
0 comments 2 minutes 603 views

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...

Tags: , ,

Microsoft Excel Functions: VLOOKUP

in Powerful Formula
0 comments 2 minutes 675 views

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...

Tags: , ,