Countif function format is covered in this quick reference guide. There are many quick reference articles available here. The countif function is a part of statistical functions in Excel and Google Sheets. It is used to count the number of cells in a range which satisfy the given condition. It uses a range and condition … Read more
Index function in Excel comes from lookup and reference function family. These functions are equally available in Excel, Google Sheets and Open Office Spreadsheet software. This article covers most of the aspects for powerful use and application of index() function in your worksheets. If you are just interested in referring to the format and parameters … Read more
Index function format is covered in this quick guide. There are many quick reference articles available here. The index function is a part of lookup and reference function in Excel and Google Sheets. It is used to get the value stored at a specific cell position. This position is addressed by rows and column index. … Read more
SUMIF function is used to sum the values specified in a range of rows and/or columns that satisfy a given condition. The function is available in Google Sheets as well as in Excel. For Example: If we want to sum only cells with value more than 100 in a range of A1 to A10 then … Read more
SUMIF function is most frequently used for data processing in the spreadsheets. This article is primarily written for the users to use the conditional sum function in the Excel as well as Google Spreadsheet programs more proficiently. The article focuses on the introduction to simple sum function, the conditional sum function sumif(), the explanation of … Read more