# Keyword Analysis & Research: countif

## Keyword Research: People who searched countif also searched

What does the countifs function do?

COUNTIF is a function to count cells that meet a single criteria. COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria. The COUNTIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

What is a countif formula?

Syntax of Excel COUNTIF Formula: Excel COUNTIF formula can be written as follows: =COUNTIF(range , criteria) Here ‘range’ specifies the range of cells over which you want to apply the ‘criteria‘. ‘criteria’ specifies the condition that a particular cell content should meet to be counted.

Why is counta counting blank cells?

In the new google spreadsheets, COUNTA is counting blank cells when referencing empty cells that are part of an arrayformula (within an arrayformula column). This is not the case with the old google spreadsheets, where COUNTA gives the expected result (0).