Whenever you type =SUM in a cell in Excel, you get a lot of functions starting with Sum… In this blog post, we will be focussing on 4 of them – SUM, SUMIF, SUMIFS, DSUM. Each of these functions has its own capability for Summing up numbers. Let’s go one by one. We will be using […]

# Formulas

# Find number of months between 2 dates in Excel

*By* rushabhs
*in* Date & Time, Formulas
6 Comments

To calculate number of months between 2 dates requires =Year and =Month formulas. Before we get into it, let us first see how to calculate number of days between 2 dates. To find number of days between 2 dates as super easy! Simply negate the 2 cells, Cell A2 has Start Date Cell B2 […]

# Index function basics – understanding the syntax

*By* rushabhs
*in* Formulas
1 Comment

Index function has advantages over Vlookup. Use it in a simple scenario like to calculate distance between 2 cities, when the data is in a table format. We want to find the distance between any of the 2 cities using the =INDEX formula. Understanding the objective Basically, whichever 2 cities you decide, you want the […]

# Vlookup with Approximate Match, Range True, Range 1

*By* rushabhs
*in* Formulas, Tips
No Comments
*Tags:* Vlookup

Normally we know that Vlookup matches value-to-value directly. For example, if you want to know the age of an employee, when you enter the employee’s code, you can vlookup his/her age directly. But now against each employee’s age, you want to enter an Age Slab based on the age in years, 0 to 20 21 […]

# OR function in Conditional formatting

*By* rushabhs
*in* Conditional Formatting, Formulas, Logical Operations
No Comments
*Tags:* OR

You have a list of expenses made during a holiday to the USA, and you want to highlight in yellow color – only the expenses made for Food and Travelling. Conditional formatting with OR function can be used for this. You could avoid using OR function, but then you would have to create 1 rule […]

# Your Trip Budget Manager in Excel

*By* rushabhs
*in* Formulas, Personal Finance
No Comments

Whenever you go on a holiday, you fix a budget in mind before hand. Are you able to keep a good track of your spends? Are you able to know at any point of time, that you should let’s say spend less on shopping as your food bills are more than expected? Are you able to […]

# How to use AND in IF formula in Excel

*By* rushabhs
*in* Formulas, Logical Operations
No Comments
*Tags:* AND

=IF is used when you want to check for a condition to be either True or False, and based on that, some action needs to be taken. The action could be some text / number to be displayed, or some formula to be executed. But if you have more than 1 condition to be checked […]

# Replace Error with data or formula with IFERROR

*By* rushabhs
*in* Formulas, Tips
No Comments
*Tags:* IFERROR

If the result of any formula is an error, you can replace it with text, numbers, or even another formula, using IFERROR function in Excel. Basically, you need to tell Excel – If this formula results in an error, do this! IFERROR works with any function, like Vlookup, IF, etc. and also with any kind […]

# Fixed Deposits Tracker – Across Banks Across Accounts

*By* rushabhs
*in* Conditional Formatting, Formulas, Tips
No Comments
*Tags:* Fixed deposit

You have 3 bank accounts and 3 members in your family. You have fixed deposits across the 3 banks for all 3 of your family’s members. How do you track all the fixed deposits in 1 single place? This 3 video series will show you how simple it is. Part 1 Part 2 Part 3 […]

# Create multiple hyperlinks in one shot

*By* rushabhs
*in* Formulas, Tips
No Comments
*Tags:* Hyperlink

Normally we use Ctrl+K to create a single Hyperlink, or Right-click on a cell and select Hyperlink. If you need to create multiple hyperlinks, these methods would be very time consuming and painful. We can instead use the function =HYPERLINK and create any number of hyperlinks in 1 shot. Let’s say I am making […]