Forum Discussion
Solved
COUNTIF to count numbers between 1 and 9, down two colums.
Can use COUNTIFS to count down two columns (Arrays) to count numbers between say 1 & 9. But can not add more logic, to count down both columns were there are numbers between 1 & 9 in adjacent rows.
...
Andrew,
Try this:
=COUNTIFS(BALL_1_RANGE,">=1",BALL_1_RANGE,"<=9",BALL_2_RANGE,">=1",BALL_2_RANGE,"<=9")
Andrew,
Try this:
=COUNTIFS(BALL_1_RANGE,">=1",BALL_1_RANGE,"<=9",BALL_2_RANGE,">=1",BALL_2_RANGE,"<=9")