Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

Category Archives for Formulas

SUMIFS and SUMIF with an OR Logic

how to use or logic in sumifs sumif in excel

Today, you will learn a simple trick to increase the power of SUMIF and SUMIFS. In SUMIFS, you can use more than one criteria to get a sum and in SUMIF you can only use one criterion. Let’s say, in SUMIFS, if you specify two different criteria, it will sum only those cells which meet […]

Check it out now

How To Calculate Ratio in Excel

how to calculate ratio in excel

Ratio calculation is one of the common methods to compare two values with each other. It can help you to compare variation between those two values. Even in our daily life, we use this word RATIO to define the comparison between two different things. Now, when you come to Excel, you don’t have any specific […]

Check it out now

Generate Random Letters in Excel

how to generate random letters in excel featured image

Ever faced a situation where you need to generate random letters? Yes, sometimes we need to generate random letters. We have functions like RAND and RANBETWEEN to generate random numbers but we don’t have any particular function to generate letters. But today, I will share with you an amazing formula trick to generate random letters in […]

Check it out now

Conditional Ranking In Excel Using Sumproduct Function

how use sumproduct in excel to create a rank if for conditional ranking

First of all, just do this for me, open your Excel workbook and try to type RANKIF. You will be wondered that there is no function in Excel for conditional ranking. Yes, there is no one. Now, just think this way, have you ever faced a situation where you have to rank values by using […]

Check it out now

How to Calculate Weighted Average With Sumproduct

how to calculate weighted average with sumproduct

The weighted mean is similar to an ordinary arithmetic mean (the most common type of average), except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.

Check it out now