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
Category
Macro VBA
How To Use Radio Buttons In Excel
In this article we will go through how to insert radio buttons in Excel, how they work and how to use the results. In another article – How To Insert Check Boxes In Excel, we went through the key differences between check boxes and radio buttons. In that article, we also did a walkthrough on … 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