SUMIF / SUMIFS with an OR Logic

how to use or logic in sumifs sumif in excel

Sometimes we need to make small amendments in formulas to make them more flexible and effective.Just like that, SUMIF OR is an advanced formula which helps you to increase the flexibility of SUMIF. Yes, you can also do SUMIFS OR.Let’s understand this first.In SUMIFS, you can use more than one criteria to get a sum […]

Check it out now

Ranks in a Pivot Table

how to add ranks in a pivot table in excel featured image

By using a pivot table, you can summarize your data in an understandable manner. And, that summary can help you to analyze data on category wise, product wise, month wise, etc.One of the common practices for analyzing data is by ranking them. Ranking categories and products can help you to compare them with each other.The […]

Check it out now

7+1 Amazing Things You Can Do with Excel Filters

amazing things you can do with excel filters

Using a filter in excel is not a #rocketscience. Everyone out there knows that they can do a lot of things with filter option. But, the bad news is they are not actually using it to the best or maybe they forget to make a habit to use it. And, the good news is you […]

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
1 8 9 10 11 12 27