Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

COUNTIFS Formula

COUNTIFS returns the number of cells in a range on the base of multiple criteria in the parameter. 

Syntax of COUNTIFS  formula:

COUNTIFS( criteria range1, criteria1,.. )

Parameters Details

• criteria range1 : Frist range of cells that you want to count based on the criteria.

• criteria1 : Frist criteria used to determine which cells to count.

• … : Next criteria range and next criteria.

Returns

The COUNTIFS function returns a numeric value.