Anyone working on Excel would have used Count many times. COUNTIF function is popular to do single criteria based counting. In case the requirement is counting of cells with multiple condition checks, then COUNTIFS is the go to function. COUNTIFS
Tag: Microsoft Excel Formulas
Sum remains one of the most used function in Excel. Many a time there is a need to do summation with multiple criteria’s. In case there are more than one condition requiring check for summation, SUMIFS is the go to
To count number of cells in excel is easy with COUNT function. When there is a need to count cells with predefined condition, then we use another function. COUNTIF function in Excel is used to count cells with pre defined
Calculating sum remains an important requirement in analysis in excel. Although doing simple sum is easy, many a times user need summation with criteria’s. For example sum is required for certain categories, sum is required at specific group level. This
Vlookup function remains one of the most widely used function in Microsoft excel. The function helps to bring data from another table to primary table, or lookup data from secondary table to primary table. This function works by looking up