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 816 views

SUMPRODUCT is a function which multiplies the corresponding components in selected arrays, and returns the sum of those calculations 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: , , , , , ,