COUNTA with Criteria

[KIM Chanthan]

Hello,

Can you help to show me about countA with criteria.
Kindly find attached file for detail.

Thank for help.
Chanthan

 

[Deepak]

Hi,

CountA dosesn't have any criteria.

Check this..
=COUNTIFS(B3:B11,E3,C3:C11,">0")

 

[Deepak]

There are some more ways to do so...

Just for info..

=SUMPRODUCT((C3:C11>0)*(B3:B11=E3))

with Ctrl+Shift+Enter

=SUM((C3:C11>0)*(B3:B11=E3))

 

[KIM Chanthan]

There are some more ways to do so...

Just for info..

=SUMPRODUCT((C3:C11>0)*(B3:B11=E3))

with Ctrl+Shift+Enter

=SUM((C3:C11>0)*(B3:B11=E3))

Thanks alot

 

[Naresh Yadav]

Pls try this one with using CTRL+SHIFT+ENTER at the end

=SUM(($B$3:$B$11=E3)*(NOT(ISBLANK($C$3:$C$11))))

 

[bosco_yip]

Another option :

=COUNTIFS(B$3:B$11,E3,C$3:C$11,"<>")