Hello Fellow Board Members,
I'm having a little brain fart today, what I'm trying to do is find in between numbers and count them, lets say I have a row of numbers:
CELL
A1 - 399
A2 - 430
A3 - 455
A4 - 499
A5 - 592
A6 - 401
A7 - 400
A8 - 525
A9 - 345
A1 - 456
What will be the formula to find lets say the numbers between 400 - 499 and then count how many numbers is equal to and in between 400 - 499? we will put the formula in cell B1.
Thank You and HAPPY 4th of July..
I'm having a little brain fart today, what I'm trying to do is find in between numbers and count them, lets say I have a row of numbers:
CELL
A1 - 399
A2 - 430
A3 - 455
A4 - 499
A5 - 592
A6 - 401
A7 - 400
A8 - 525
A9 - 345
A1 - 456
What will be the formula to find lets say the numbers between 400 - 499 and then count how many numbers is equal to and in between 400 - 499? we will put the formula in cell B1.
Thank You and HAPPY 4th of July..