## Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]

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,

## How to Calculate Weighted Average in Excel

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.

## How to use Excel 3D Reference in Excel

We all want to save our time. And, by using 3D Reference in Excel you can save your a lot of time. It’s is like three-dimensional chart or image which has more

## How to use SUMPRODUCT IF to Create a Conditional Formula in Excel

SUMPRODUCT is one of the most important Excel functions. And the best part about it is, you can modify it in several ways.And, one of its powers which I have discovered

## How to Multiply in Excel Using Paste Special Option

Sometimes in Excel, you need to perform some quick calculations. And, you can use paste special for these quick calculations… …instead of formulas.In paste special, you have four different options [Add, Subtract,

## How To Perform Two Way Lookup In Excel

It happens sometimes… …when we need to lookup for a value from a table… …according to the row heading and… …column heading.It happens sometimes when we need to lookup for a value from