Excel 2007 brought a host of new functions to Excel that were missing in Excel 2003. One of these functions was AVERAGEIF which returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. One essential function that is still missing is MEDIANIF or MEDIAN IF which should ideally return the median of all the cells in a range that meet a given criteria.
Search Results for: excel
If you’ve forgotten the password to edit the Excel file Excel Password Remover 2008 can come to your rescue. Excel Password Remover is a FREE Excel add-in that removes/cracks sheet and workbook password protection in ExcelÂ®. This program will remove passwords of any length, also passwords containing special characters.
If you have lost your password for any MS Word or Excel document and are unable to recover it, try using this Free Word / Excel Password Recovery application. It’s a freeware product and all you need to do is install it, open the file that you need to recover. Choose the character set “a to z” and the expected lenght of your password and click GO.
This is one very powerful and, in my opinion, less used feature of Microsoft Excel. Many of you are familiar with Paste Special, also popularly… Read More »This amazing Excel shortcut will save you hours!
I’ve covered the basics of Net Present Value (NPV) previously. If you don’t know what NPV is, then please read that post first before continuing.… Read More »How to calculate NPV in Excel using Formulae
As part of my day job, I’ve spent a lot of time working with Microsoft Excel and Microsoft PowerPoint. Not only with 2010, but also with… Read More »2 Tips to become more efficient at Microsoft Excel
The title of the post is a bit of a misnomer because the SUMIF function in Excel does not allow you to have more than condition.
Excel 2007 introduced the SUMIFS function which allowed for multiple conditions. However, if you are using any version prior to Excel 2007 or if the persons who will be using your Excel workbook will be using a version prior to Excel 2007, then the SUMIF function will throw up an error.
That is a problem a colleague faced at work. To solve this problem you can use SUMPRODUCT along with double negation. The double negation is simply two minus signs one after an another. The net effect is that it doesn’t change the value of the calculations.
Way back in 2008, I wrote about using SUMPRODUCT to duplicate the functionality of SUMIFS which was introduced in Microsoft Excel 2007. SUMPRODUCT is a powerful excel function and is more commonly used to multiply two arrays. Let’s first understand the syntax of SUMPRODUCT.
One requirement that you will see as part of a classroom environment is the necessity to create groups. One option is to perform this process manually. This is OK if you have ten people.
Continuing with our Excel Tutorials, in this article, I’ll take you through using Goal Seek in Microsoft Excel 2007. The function is same as that of earlier versions of Excel as well as Excel 2010. The screenshots below are taken in 2007.