Learn Microsoft Excel Online FreeThis post will guide you how to show only positive values in an excel formula. How to show formula result only if it is a positive value in excel. Is there a way to have a formula return only positive numbers in excel. Show Only Positive Values Assuming that you have a list of data,… read more »
This post will guide you how to sum a specific Row or Column in a named range in excel. Normally, you can easily sum a certain row or column in a worksheet in excel. But if you just want to sum a particular column or row in a named range, how to achieve it in… read more »
This post will guide you how to limit formula result to a maximum or minimum value in excel. For example, if you want to limit the results of a formula to a maximum value of 200, how to this this in excel. How do I return a formula result only within a specified minimum or… read more »
This post will guide you how to sort cells or text values in a column based on a specific word even if the word is in the text string in the cell. How do I sort cells in a column by the number of a specific word or words in excel. Sort Cells by Specific… read more »
This post explains that how to limit calculated cell using Data Validation in excel. You can use the Data Validation function to limit what a user can type in a cell. And you can also use the data validation to limit user to whole number, dates, a list of selections or a specific range of… read more »
This post will explains that how to use the Excel 3-D reference to reference the same cell or a range of cells on multiple worksheets, then try to sum the same cell range from multiple worksheet with an Excel formula. The 3-D reference refers to the same cell or range on multiple sheets. And it… read more »
This post will discuss that how to count the number of cells that contain specific text or certain text in a specified cells of range in Excel. How to get the total number of cells that contain certain text. Count Cells That Contain Specific Text Assuming that you have a data of list in range… read more »
This post will guide you how to use Excel SUMIF function with syntax and examples in Microsoft excel. Description The Excel SUMIF function sum the numbers in the range of cells that meet a single criteria that you specify. You can use the SUMIF function to sum cells that based on the dates, numbers or… read more »
This post explains that how to count numbers with leading zeros as Text format in excel. How to count numeric format strings with a different number of leading zeros using excel formula. Count Strings with Leading Zeros Suppost you have a list of product ID in your worksheet, and the product ID contains the different… read more »
We have described that how to lookup value and retrieve the entire column in the previous post. And this post will guide you how to get the sum of the entire column with lookup value in a range in excel. SUM Column with Lookup Value If you want to lookup value in a range and… read more »
