The first range in which to evaluate the associated criteria. Count Formula in excel is used to count the numbers of data in a range of cells the condition to this formula is that this formula only counts the numbers and no other texts for example if we have a formula as Count 1 e 2 then the result displayed is 2 rather than three as the formula only counts the numbers. Syntax of Excel COUNTIF Formula.
You could also use the COUNTIFS function.
COUNTIFS function can take multiple criteria as the arguments and counts the cells only when all the criteria are TRUE. Additional conditions must follow the same rules. COUNTIF A1A10 100 count cells equal to 100 COUNTIF A1A10 32 count cells greater than 32 COUNTIF A1A10 jim count cells equal to jim Value from another cell A value from another cell can be included in criteria using concatenation. Countif by a certain month Supposing you are going to count birthdays which are in a specific month of 8 you can enter below formula into a blank cell and then press the Enter key.