How to use Count formula?

[Kutty]

Hai Friends!
How to use count formula in different range and different criteria?

 

[chirayu]

attached sample

 

[Khalid NGO]

Hi,

@chirayu I think OP don't want to count if corresponding value is blank.

this will work:
=COUNTIFS($A$2:$A$22,D2,$B$2:$B$22,">"&0)

or this {array}
=SUM(SIGN(IF($A$2:$A$22=D2,$B$2:$B$22)))
with CSE

Regards,

 

[Kutty]

hai @chirayu I want to count the column T.No.

 

[Kutty]

Thanks @Khalid NGO

 

[Kutty]

some excel files have only one criteria_range and some other excel file have more than one criteria_range. so I confused instead of that ...

 

[Khalid NGO]

some excel files have only one criteria_range and some other excel file have more than one criteria_range. so I confused instead of that ...
View attachment 24831

Hi,

Unnecessary confusion here.

Just type =COUNTIFS(
now press and hold Comma ","
you will see the difference.

criteria_range and criteria are separated by Comma.

Regards,

 

[Kutty]

Thank you @Khalid NGO