Count excel

[thifu3]

i want to count a letter if the next cell is greater than zero.

A B

5 years 2
10 years 3
5 years 0
10 years 4
5 years 0

count how many "5 years " are greater than zero.

 

[vijay.vizzu]

Dear thifu3,

You can use =COUNTIFS() to get the results. As per your data range, =COUNTIFS(A1:A5,A11,B1:B5,">0"), in this i used A11 as criteria (5 Years).

 

[GFC]

Good evening,

=SUMPRODUCT((D5:D9="5 years")*1;(E5:E9=0)*1)

You can of course put your criteria in separte cells e.g.
=SUMPRODUCT((D5:D9=D13)*1;(E5:E9=E13)*1)