COUNTIFS – Count rows automatically in Excel
The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.
formula to count rows
Function COUNTIF
The COUNTIF function returns the number of rows within a range according to a criteria. Many situations are possible.
