Introduction COUNTIF () function constitutes a family of functions that is used for counting and specially for counting conditionally. We said that COUNTIF () is a family because there are few other similar function that are present in Excel that starts with COUNTIF. These functions include COUNTIFS() that is used for counting more than one criteria, COUNTA () that is used … [Read more...]
Getting Most Out of COUNTIF() and COUNTIFS() function in Excel
Introduction: There are instances when we are interested in counting things. This is true for accountants, engineers, managers and so on. To count, we usually record quantities, either on paper on spread – or if we record on paper, we eventually transfer it to a spreadsheet to make calculations more manageable. COUNTIF() or COUNTIFS() is the function that we use when doing … [Read more...]