B
Byron720
I have the following data:
w 1
w 1
w 2
w 1
w 1
c 3
w 2
c 1
c 1
w 3
c 1
I need a formula that calculates how many of the w's have numbers greater
than 1. I was trying this formula: sumproduct(--(C2:C12="W"),--(D212>1))
but it doesn't work.
w 1
w 1
w 2
w 1
w 1
c 3
w 2
c 1
c 1
w 3
c 1
I need a formula that calculates how many of the w's have numbers greater
than 1. I was trying this formula: sumproduct(--(C2:C12="W"),--(D212>1))
but it doesn't work.