Here's how to use the COUNTIF Excel function . Use it to count the number of cells in a range based on your chosen criteria. Video included. In its simplest form, COUNTIF says: = COUNTIF (Where do you want to look?, What do you want to look for?) For example: The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to use COUNTIF , COUNTIFS and FILTER functions to count cells that meet multiple criteria in Excel . See examples of OR, AND and combined logic, as well as tips and tricks for different scenarios. Learn how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel based on AND or OR logic. See examples for numbers, dates, text, wildcard characters and more.
