I
icystorm
There are two bouncing balls. Let's call them "red" and "blue". I want
to count the number of times each ball bounces higher than one inch
when dropped.
A1, B1
ball, height of bounce (inches)
red, 2.30
red, 1.20
red, 0.90
red, 0.25
blue, 2.35
blue, 1.22
blue, 0.91
blue, 0.23
For the red ball bounces that meets the bounce height criteria...
{=SUMPRODUCT($A$2:$A$9="red")*($B$2:$B$9>1)}
....returns 2.
Likewise for the blue ball.
---
Next, regardless of how many times the red ball bounces higher than
one inch, if it happens at least once, I only want to count it as a
single event, rather than multiple events. Likewise for the blue ball.
{=IF(SUMPRODUCT(($A$2:$A$9="red")*($B$2:$B$5>1))>0,1,0)}
....returns 1, as desired, for the red ball. Likewise for the blue
ball.
---
Okay, now the complicated part...
I want to place the results of the red ball and blue ball single
events in a single cell.
The result should be two in my example, because the red ball bounced
higher than one inch twice, as did the blue ball, so each instance
counts as a single event per ball.
Any recommendations?
to count the number of times each ball bounces higher than one inch
when dropped.
A1, B1
ball, height of bounce (inches)
red, 2.30
red, 1.20
red, 0.90
red, 0.25
blue, 2.35
blue, 1.22
blue, 0.91
blue, 0.23
For the red ball bounces that meets the bounce height criteria...
{=SUMPRODUCT($A$2:$A$9="red")*($B$2:$B$9>1)}
....returns 2.
Likewise for the blue ball.
---
Next, regardless of how many times the red ball bounces higher than
one inch, if it happens at least once, I only want to count it as a
single event, rather than multiple events. Likewise for the blue ball.
{=IF(SUMPRODUCT(($A$2:$A$9="red")*($B$2:$B$5>1))>0,1,0)}
....returns 1, as desired, for the red ball. Likewise for the blue
ball.
---
Okay, now the complicated part...
I want to place the results of the red ball and blue ball single
events in a single cell.
The result should be two in my example, because the red ball bounced
higher than one inch twice, as did the blue ball, so each instance
counts as a single event per ball.
Any recommendations?