Count multiple criteria and values

[eemhuynh]

Hey guys, I needed a formula to count the below - e.g. picking up name “Alex” as a criteria, ignoring both blank cells and nil value in Value column. So, for the below example count for Alex with value should be 1.

And essentially cleansing rows with blank value cell is not an option.

Thanks in advance

Name	value
Alex	0
Alex
Alex
Berty	25
Alex	61
Berty

 

[hagia_sofia]

Do you mean something like:

=COUNTIFS(A2:A7,"Alex",B2:B7,">"&0)

 

[eemhuynh]

Do you mean something like:

=COUNTIFS(A2:A7,"Alex",B2:B7,">"&0)

That’s perfect. Thank you!!!