How to use multiple criteria using Countifs function in Excel
Excel allows you to solve complex situation using functions. You can use multiple criteria using Countifs function to get the correct result.
#Excel
189 postsHow to use COUNTIFS and SUMIF together in Excel
COUNTIFS and SUMIF important functions of Excel. If you have complex criteria then you can use these functions to get the result…
How to use index and match functions for advanced lookup in Excel
Index match is an important function which allows you to search the value. you can use index and match functions for advanced…
Excel FV Function to know future value of an Investment
Excel FV Function in an important financial function which allows you to know future value of an Investment based on constant payment,…
Latest 7 Excel Tricks which makes you an Excel Expert
Excel allows you to use tips and tricks for quick working. Latest 7 Excel tricks which makes you an Excel Expert in…
Beauty of Goal Seek feature in Excel to Find the Answer
Goal Seek is an important part of What-If-Analysis. Goal Seek feature in Excel allows you to to see how one variable value…
How to use Countif function with wildcards in Excel
Countif function is used to count number of cells which meet the given single criteria. Countif function also support ? and *…
How to convert standard date mm-dd-yyyy format into mm/dd/ format
By default Excel used MM-DD-YYYY format during filling the dates. Excel allows you to quickly convert standard date mm-dd-yyyy format into mm/dd/…
Guide to print selected range of cells in MS Excel
If large database and want to print any required area then you must read this article how to print selected range of…
MS Excel tips rapidly erase blank cells from excel
best tips and tricks available of Microsoft Excel. Kindly read quick and easy way of MS Excel tips rapidly erase blank cells…