Tuesday 5 December 2017

Excel - Excel Count Functions




Count Cells with Data - COUNTA
Count Blank Cells -- COUNTBLANK



Count cells that match criteria - COUNTIF7


Change Operator for COUNTIF Function

Count cells that match multiple criteria -- COUNTIFS
Count cells that match multiple criteria -SUMPRODUCT
Count Rows in a Filtered List -- SUBTOTAL

Count Specific Items in a Filtered List



Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London









No comments:

Post a Comment