## How to Calculate Sum or Count Based on Cell Colors

In this article we will do a step by step guide on how to add up values based on cell colors. And then we will go through how to count the number of cells that are of a particular color. We will be doing so using Visual Basic for Applications (VBA). However this method is … Continue Reading

## SUMIF – SUM IF Condition is Met

Similar to the COUNTIF function, SUMIF is also one of the most fundamental functions to use in Excel when it comes to reporting and data analysis. In this article, we will go through how this function works and also explain why values may not be adding up correctly. We will also apply multiple conditions in … Continue Reading

## User-Defined Functions – Writing Your Own Functions in Excel

There are over 500 built-in functions in Excel but yet you may have trouble finding one that suits your need. Are there calculations that you do on a regular basis over and over again? And you are tired of typing in that same formula in again and again every time. You can save time by … Continue Reading

## How To Enable Macro/Visual Basic for Application (VBA)

To enable Macro/Visual Basic for Application (VBA) in Excel, there are two steps. Before we start, let’s talk about what Macro and VBA are about. Macro is a recording tool in Excel – we press a button to “start recording”, we then do a series of activities/processes and at the end we press a button … Continue Reading