Full and Part Summaries with the Dictionary

Creating summaries using the Excel VBA scripting dictionary is something you will want to learn. The dictionary is powerful and can summarise data very quickly. This blog post takes you through the process of using the Excel Scripting Dictionary.

Tags Excel, scripting dictionary, Sum, Multiple, Columns

Adding Mulitple Criteria in a Single Column

Creating a sum where the criteria is in the same column has usually been about creating a sumif or sumifs and adding multiple iterations together. This turns formula which intuitively should be short into long, difficult to read formulations. With the intelligent use of Sumproduct you can use one formula to capture multiple criteria in the same column. Here is an example.

Tags Excel, Sum, Multiple, same column